![](https://seccdn.libravatar.org/avatar/eb285856d0e2555b263c3583d0abf430.jpg?s=120&d=mm&r=g)
Art Fore wrote:
Found the documentation, went through it, created a database, started postmaster, but cannot get access to the database as user, I get permission denied. Supposedly the user should have access, but no such luck. Also, files are not where the documentation says they should be.
First of all you need to make yourself a Postgres user. You have to be user "postgres" to do this, which is best done in a roundabout way: 1) log in as root 2) type "su - postgres" (you now become user "postgres") 3) Start the SQL monitor with the command "psql template1" (template1 is the test database supplied when you install) 4) Now you can create a user. Type "\h create user" to see the help for creating a new user. Pay special attention to the options "CREATEDB" and "CREATEUSER". You can get general help on the "backslash" commands by typing "\?". 5) If you want to have remote access to the database using the C libraries or the Java JDBC driver over TCP/IP, make sure you are starting postmaster with the "-i" option. In SuSE 8.1, this is done by setting POSTGRES_OPTIONS="-i" in /etc/sysconfig/postgresql. You will also want to have a look at /var/lib/pgsql/data/pg_hba.conf. HTH, if you need more information you can always schlep yourself over to: http://www.postgresql.org/ Their mailing lists are especially helpful. -- ============================================================== Glenn Holmer (Linux registered user #16682) -------------------------------------------------------------- If you make a small change to a program, it can result in an enormous change in what the program does. If nature worked that way, the universe would crash all the time. -------------------------------------------------------------- -Jaron Lanier ==============================================================