dbTalk Databases Forums  

problem with connecting to postgresql server

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss problem with connecting to postgresql server in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
gavaneh
 
Posts: n/a

Default problem with connecting to postgresql server - 01-04-2004 , 12:27 AM






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


Reply With Quote
  #2  
Old   
Bruno LEVEQUE
 
Posts: n/a

Default Re: problem with connecting to postgresql server - 01-04-2004 , 09:04 AM






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:

Quote:
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 (AT) net6d (DOT) com
http://www.net6d.com


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.