Re: problem with connecting to postgresql server - Mailing list pgsql-novice

From Bruno LEVEQUE
Subject Re: problem with connecting to postgresql server
Date
Msg-id 3FF82B76.9090908@net6d.com
Whole thread Raw
In response to problem with connecting to postgresql server  (gavaneh <gavaneh@yahoo.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: gavaneh
Date:
Subject: problem with connecting to postgresql server
Next
From: Olaf Ferger
Date:
Subject: vacuumdb output changed after upgrade from 7.3.4 to 7.4.1