On Fri, 12 May 2006 12:43:05 -0300, Bruno Lustosa wrote
> 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
>
Thanks, that helps.
Pat
--
[email protected] mailing list
