Re: Permission Problems:-)?

On Tuesday 27 January 2004 12:05 am, Richard Huxton wrote:

>
> OK - it's complaining it can't connect to template1. This is the database
> that contains all the default tables/types/functions etc. that will appear
> in your new database.
>
> First thing to check is that PG is running. Does it show up in "ps auxw |
> grep postgres"?
>
> If it's running you should check if you can connect to the template1
> database normally. As the postgres user try "psql template1" and see if you
> can connect to the DB. If not, you need to look at your pg_hba.conf file
> (probably in /var/lib/pgsql/data or similar) and also read the chapter on
> client authentication in the manuals (tip - start with trust for localhost
> and work outwards).
>
> If PG is running and you can connect to the template1 database, try the
> command again (as user postgres). If it still doesn't work log into
> template1 and try a "CREATE DATABASE" command (see manual for details).
> Then, come back to the list and let us know what happened.

I have now created a database as user postgre. Thank you!

However I'm still having problems using it as a normal user. I added myself
to the postgres user group but it didn't work.
This is my default configuration:

# CAUTION: The default configuration allows any local user to connect
# using any PostgreSQL user name, including the superuser, over either
# Unix-domain sockets or TCP/IP.

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

#local all all trust
# IPv4-style local connections:
#host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
#host all all ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust
local all all ident
sameuser
"/var/lib/pgsql/data/pg_hba.conf" 63L, 3374C 63,1
Bot

When I check to see if PG is running as a normal user I get this:

:~> ps auxw | grep postgres
postgres 11956 0.0 0.2 17960 2296 pts/3 S Jan26
0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
postgres 11959 0.0 0.2 8760 2072 pts/3 S Jan26 0:00 postgres: stats
buffer process
postgres 11960 0.0 0.2 7768 2120 pts/3 S Jan26 0:00 postgres: stats
collector process
adriel 14819 0.0 0.0 1828 604 pts/2 R 11:26 0:00 grep postgres

And when I try to create the db as a normal user I get this:

:~> createdb mydb1
createdb: could not connect to database template1: FATAL: user "adriel" does
not exist

So...whats next?
Jerome