Re: [ADMIN] pgsql initial superuser

2004-06-03 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Pedro , Hello. this is my "first" time using pgsql, and I seem to be running to a bit of a corner here :-) I've understood how to add a superuser/database-user/user but I have no user to begin with. ~# createuser superuser Shall the new user be allowed to create databases? (y/n) y Shall th

Re: [ADMIN] pgsql initial superuser

2004-02-16 Thread Pedro Almeida
That was it - user 'postgres', owner of postmaster, has got what it takes. Thank you for solving my problem and giving me some extra tips to work on. I will now continue lurking on the ML and watching closely your discussions. Good bye then :-) ---(end of broadcast)---

Re: [ADMIN] pgsql initial superuser

2004-02-16 Thread Gémes Géza
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pedro Almeida írta: | kaolin fire wrote: | |> try user 'pgsql' :) that's the default initially created superuser, no |> password (it would be good to give it one). |> |> -kaolin fire |> -http://erif.org/code/fallingup/ for a 'spin' on tetris |> |> | Tha

Re: [ADMIN] pgsql initial superuser

2004-02-16 Thread Peter Eisentraut
Pedro Almeida wrote: > So I need someway to add a user so I can add others. There should be a predefined user named "postgres". ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] pgsql initial superuser

2004-02-16 Thread Pedro Almeida
kaolin fire wrote: try user 'pgsql' :) that's the default initially created superuser, no password (it would be good to give it one). -kaolin fire -http://erif.org/code/fallingup/ for a 'spin' on tetris That was a quick response :-) using a clean pg_hba.conf file (no user lines added), this is

[ADMIN] pgsql initial superuser

2004-02-16 Thread Pedro Almeida
Hello. this is my "first" time using pgsql, and I seem to be running to a bit of a corner here :-) I've understood how to add a superuser/database-user/user but I have no user to begin with. ~# createuser superuser Shall the new user be allowed to create databases? (y/n) y Shall the new user be