Re: problem with connecting to postgresql server

From: Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com>
To: gavaneh <gavaneh(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem with connecting to postgresql server
Date: 2004-01-04 15:04:22
Message-ID: 3FF82B76.9090908@net6d.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)leveque(at)net6d(dot)com
http://www.net6d.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Dan Jewett 2004-01-04 20:11:17 Timestamp vs. Interval and formatting....
Previous Message gavaneh 2004-01-04 06:27:47 problem with connecting to postgresql server