/tmp/.s.PGSQL.5432

[Davifflaelan]

Ok, so I've installed SQL-Ledger & all the little requirements it, well.. required [img]<___base_url___>/uploads/emoticons/default_laugh.png[/img]

 

So now I'm up too building SQL-Ledgers Database & I keep getting this error msg(I'll also write the steps too the issuse):-

 

root@crazed-weasel:~# su postgres

postgres@crazed-weasel:/root$ createuser -D sql-ledger

could not change directory to "/root"

Shall the new role be a superuser? (y/n) n

Shall the new role be allowed to create more new roles? (y/n) y

createuser: could not connect to database postgres: could not connect to server: No such file or directory

Is the server running locally and accepting

connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

 

 

Typing into google got me this:-

 

[/url][url=http://archives.postgresql.org/pgsql-admin...05/msg00196.php]http://archives.postgresql.org/pgsql-admin...05/msg00196.php

 

"Lee Wu" <Lwu ( at ) mxlogic ( dot ) com> writes:

> We noticed that we deleted /tmp/.s.PGSQL.5432 accidentally. However,

> anything seems fine.

 

> What is impact of removing it?

 

Anything that tries to connect to your postmaster via that socket will

fail. You might want to restart the postmaster to bring back the

socket.

 

regards, tom lane

 

which had me type the following in command prompt:-

 

postgres@crazed-weasel:/root$ postmaster

 

Which give me back this:-

 

postmaster does not know where to find the server configuration file.

You must specify the --config-file or -D invocation option or set the PGDATA environment variable.

 

At this point I am completely at a loss of what too do :(

 

 

I am using Slackware 11 on a Pent 3 866Mhz machine.

 

P.S. The only reason why I'm bothering with SQL is for the program I wrote about in my hello msg(Been workin on this SQL crap for over 2 months now... [img]<___base_url___>/uploads/emoticons/default_mad.gif[/img] HELP ME I'M SO SICK OF IT :(