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