Re: Postgresql doubt ..

[p <pplaw@pcisys.net>]

On Mon, Nov 19, 2001 at 08:36:30PM +0000, p wrote:
> On Mon, Nov 19, 2001 at 09:45:55PM +0530, shyamk@eth.net wrote:
> > [shyam@home shyam]$ xhost +
> > [shyam@home shyam]$ su postgres
> > bash $createdb shyamdb
> > psql.connectDBStart() ... connect() failed : Cannot respond
> >      Is the postmaster running at 'localhost' & accepting connection on Unix socket
> > '1234' ?
> > createdb : database creation failed.
> > 
> > xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > 
> > Dear members ,
> >    Can anybody please tell me what the above means , and how to circumvent it ?
> >    I am actually sitting on postgresql for the first time ,
> > and am startled .
> > 
> > Please help ...
> > (shyamk@eth.net)
> > Shyam
> > 
> > 
> //
> 
> hi,
> 
> 
> here's all i did:
> 
> 1.  # su postgres
> 
> 2.  createuser <foo>
> 
> 3.  createdb <foo>
> 
> 4.  $ psql <data-base foo:  the "foo" for #3 above>
> 
> 
> 
> synopsis:
> 
> 1:  to change to postres "administrator"; 
> 
> 2:  to create "user"/non-root access (to the postgres
>     "server");
> 
> 3:  to create a database; 
> 
> 4:  to start a "console" session of postgresql.  (or,
>     if you want a gui "frontend," try (apt-get install)
>     pgaccess or gtksql.) 
> 
> 
> hth.
> 
> bentley taylor.
> 
> //

...sorry, upon re-reading your email, i should have just
said that "$ su postgres" should be "# su postgres" (or
in other words, it should be setup as "root.")

bentley taylor.

//