[opensuse] PostgreSQL password
Disclaimer: I am new to PostgreSQL. My previous experience is MySQL and SQLite. I am attempting to set up a PostgreSQL/PostGIS database server on openSUSE (12.3 - but I do not think that matters at this point). I have installed the server and what I think to be reasonable packages. I have made no changes to any configuration files, so it is pretty much out-of-the-openSUSE-box. The postgresql server is running: postgres 4937 1 0 10:59 ? 00:00:00 /usr/lib/postgresql92/bin/postgres -D /var/lib/pgsql/data postgres 4938 4937 0 10:59 ? 00:00:00 postgres: logger process postgres 4940 4937 0 10:59 ? 00:00:00 postgres: checkpointer process postgres 4941 4937 0 10:59 ? 00:00:00 postgres: writer process postgres 4942 4937 0 10:59 ? 00:00:00 postgres: wal writer process postgres 4943 4937 0 10:59 ? 00:00:00 postgres: autovacuum launcher process postgres 4944 4937 0 10:59 ? 00:00:00 postgres: stats collector process Now I want to do something along the lines of this: $ createuser <username> $ createdb -E UTF8 -O <username> gis To do this, I must log in as the postgres user. The problem is I do not know the password. Now, of course I can change the Linux user password for postgres. But will that effect the starting of the PostgreSQL server? I surely do not want to change the password and mess up starting the server again. And there are no backsies here. The second question is, after I have changed the Linux password and can run commands, won't I need the password for the database cluster? Or, in the openSUSE install, is that the same? I understand that PostgreSQL can use PAM authentication. But does it in the openSUSE RPMs? The SUSE docs in these packages could perhaps give a hint of what they have and have not done in the installation process so a user knows where to pick up the ball. Yours sincerely, Roger Oberholtzer Ramböll RST / Systems Office: Int +46 10-615 60 20 Mobile: Int +46 70-815 1696 roger.oberholtzer@ramboll.se ________________________________________ Ramböll Sverige AB Krukmakargatan 21 P.O. Box 17009 SE-104 62 Stockholm, Sweden www.rambollrst.se -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On Wed, 20 Feb 2013 11:43:29 +0100 <snipped>
Hi Roger, You piqued my curiosity as I keep contemplating (then never finding the time) to try PostgreSQL on oS so I did a quick Google search. These posts look promising... http://blog.milczarek.it/2012/09/install-postgresql-on-opensuse-12-1/ http://haulynjason.net/weblog/2012/02/install-postgresql-on-opensuse-12-1/ http://xadmin.info/?p=284 hth & regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On Wed, 2013-02-20 at 06:34 -0500, Carl Hartung wrote:
Thanks for that info. I decided to solve becoming the postgres user by first becoming root. Then I do not need the postgres password. I have not found a need to change the password in the database as those examples show. So I did not do that. I have now been able to create my user and a table. My new issue is that I cannot get the postgis stuff working. When I run: psql -d gis -f /usr/share/postgresql91/contrib/postgis-2.0/postgis.sql I get: psql:/usr/share/postgresql91/contrib/postgis-2.0/postgis.sql:45: ERROR: could not access file "$libdir/postgis-2.0": No such file or directory May be a chroot that the openSUSE RPMs don't have correct. This is as far as I have gotten: http://lists.osgeo.org/pipermail/postgis-users/2012-September/035054.html I have not solved this one yet. Yours sincerely, Roger Oberholtzer Ramböll RST / Systems Office: Int +46 10-615 60 20 Mobile: Int +46 70-815 1696 roger.oberholtzer@ramboll.se ________________________________________ Ramböll Sverige AB Krukmakargatan 21 P.O. Box 17009 SE-104 62 Stockholm, Sweden www.rambollrst.se -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On Wed, 2013-02-20 at 12:59 +0100, Roger Oberholtzer wrote:
http://lists.osgeo.org/pipermail/postgis-users/2012-September/035054.html
I have not solved this one yet.
I think the problem is that the postgis package is not replacing $libdir with the actual path. When I replace the string (in hundreds of places in a couple files), I get further: psql:/usr/share/postgresql91/contrib/postgis-2.0/postgis.sql:45: ERROR: incompatible library "/usr/lib/postgresql91/lib/postgis-2.0.so": version mismatch DETAIL: Server is version 9.2, library is version 9.1. I was suspicious why the postgis stuff was in a directory called postgresql91... It seems PostGIS will not build with PostgreSQL 9.2.3 because of an undefined symbol. So, until that is sorted out, I have to wait. Yours sincerely, Roger Oberholtzer Ramböll RST / Systems Office: Int +46 10-615 60 20 Mobile: Int +46 70-815 1696 roger.oberholtzer@ramboll.se ________________________________________ Ramböll Sverige AB Krukmakargatan 21 P.O. Box 17009 SE-104 62 Stockholm, Sweden www.rambollrst.se -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On Wed, 2013-02-20 at 14:50 +0100, Roger Oberholtzer wrote:
It seems PostGIS will not build with PostgreSQL 9.2.3 because of an undefined symbol. So, until that is sorted out, I have to wait.
This is Bugzilla #804724 Yours sincerely, Roger Oberholtzer Ramböll RST / Systems Office: Int +46 10-615 60 20 Mobile: Int +46 70-815 1696 roger.oberholtzer@ramboll.se ________________________________________ Ramböll Sverige AB Krukmakargatan 21 P.O. Box 17009 SE-104 62 Stockholm, Sweden www.rambollrst.se -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (2)
-
Carl Hartung
-
Roger Oberholtzer