hello

does anyone know where postgresql databases are stored?

i know mysql is on /var/lib/mysql

i looked at /var/lib/pgsql but didn't find the databases/usernames that one of my clients have... i want to find that because 2 misterious databases ("110" and "111") appeared after I reinstalled pgsql and i don't get to delete them (cpanel says "database deleted", but it still remain in the menu)

thanks

/var/lib/pgsql/data

From there check the base folder. Make sure to stop postgresql before you delete anything.

Originally posted by DynamoHost
/var/lib/pgsql/data

From there check the base folder. Make sure to stop postgresql before you delete anything.

thanks

i just checked and that's in fact a user, and not a database

two users: "110" and "111"

i couldn't find them anywhere
even search t he whole /lib/var/pgsql/ for files containing "110" and couldn't find too much

any suggestions?

thanks

Just log in to psql (the command client). To delete a database, write "DELETE DATABASE databaseName;". To delete a user account, write "DROP USER username;".

http://www.postgresql.org/docs/7.4/interactive/

Originally posted by jonaskb
Just log in to psql (the command client). To delete a database, write "DELETE DATABASE databaseName;". To delete a user account, write "DROP USER username;".

http://www.postgresql.org/docs/7.4/interactive/

hello

i runned psql as root
it asked password
i typed the one that's on /root/.pgpass and got:
psql: FATAL: Password authentication failed for user "root"

any ideas?

thanks

Can't remember how to reset the root password. Check the documentation (there's a link in my previous post) and/or google the errror message you got.

you have most likely have to log in as user postgres
just su from root to postgres and then type pgsql; and you should be in.