On 5/12/06, pat <[EMAIL PROTECTED]> wrote:
I've installed a postgres SQL and trying to connect into it. Does the installation contains a testing DB ??? Is there a super user for the it (somethink like sysdb, system etc. in oracle) and if yes what is its default passwd.
The superuser for postgresql is 'postgres'. You can su to root, and then 'su postgres' to connect to the database, as the postgres user doesn't have a password by default. You can use the template1 database to connect to the server, and then create more databases. So: $ su root Password: # su postgres $ psql template1 Hope this helps -- Bruno Lustosa <[EMAIL PROTECTED]> http://www.lustosa.net/ -- gentoo-user@gentoo.org mailing list
