Thread: problem with connecting to postgresql server

problem with connecting to postgresql server

From
gavaneh
Date:
Hi
I am a novice in using postgresql and I've faced to a
problem at the beginning of my work....

I have Linux OS on my computer and it has postgresql
server but I cant use it...whenever I want to make a
table
it says that "it can not connect to the server" and it
seems it's because no user has an ID on this server...
how can I make my server work?

thnx in advance

 Novice....

__________________________________
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003

Re: problem with connecting to postgresql server

From
Bruno LEVEQUE
Date:
Hi,
If you cannot see a postmaster running in a ps -ax list, you need :
1 - find where your data (files of the database are)
2 - Have you done an initdb ?
3 - postmaster -i -D DirectoryOfYourData -S

You must run postmaster with the owner of your data directory (postgres ?).
Depends of what kind of installation you done.

If you have used createuser you can connect with : psql -U UserCreated, in
other case try postgres like user.

Bruno


gavaneh wrote:

>Hi
>I am a novice in using postgresql and I've faced to a
>problem at the beginning of my work....
>
>I have Linux OS on my computer and it has postgresql
>server but I cant use it...whenever I want to make a
>table
>it says that "it can not connect to the server" and it
>seems it's because no user has an ID on this server...
>how can I make my server work?
>
>thnx in advance
>
> Novice....
>
>__________________________________
>Do you Yahoo!?
>Find out what made the Top Yahoo! Searches of 2003
>http://search.yahoo.com/top2003
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com