LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-01-2010, 08:47 AM   #1
idrissess
LQ Newbie
 
Registered: Jul 2010
Location: Mahdia Tunisia
Distribution: fedora10
Posts: 20

Rep: Reputation: 0
Unhappy postgresql problem


HI; i have installed postgresql.but icannot launched it
root@ubuntu:~# service postgresql start
postgresql: unrecognized service
root@ubuntu:~# su postgres
postgres@ubuntu:/root$ psql
could not change directory to "/root"
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
postgres@ubuntu:/root$


also i cannot find the directory postgresql in /etc/init.d


root@ubuntu:~# pg_lsclusters
Version Cluster Port Status Owner Data directory Log file

i tried often to reinstall postgresql but not success
please i need help
thanks.

Last edited by idrissess; 08-01-2010 at 08:54 AM.
 
Old 08-01-2010, 11:36 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Not overly familiar with how Ubuntu handles postgres, but try
to "su - postgres" to begin with. The obvious problem you're
facing is that your postgres user doesn't have permission to
be in the directory in which you are trying to do stuff.

Switching with '-' will put you in postgres' home.

[edit]
A bit of googling suggests that ubuntu uses /etc/init.d/postgresql-X.Y
for startup ...
[/edit]


Cheers,
Tink

Last edited by Tinkster; 08-01-2010 at 11:45 PM. Reason: [edit]
 
Old 08-02-2010, 12:14 AM   #3
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,679
Blog Entries: 29

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
I suggest that you uninstall postgres and then install it again !

Are you using Postgres on Ubuntu ?

Did you install it from some .deb package or synaptic package manager or .tar.gz ?


For installing postgres:
https://help.ubuntu.com/community/PostgreSQL
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
postgresql problem eduac Linux - Software 0 08-31-2005 06:45 AM
PostgreSQL Problem r0ck Slackware 8 11-26-2004 11:02 AM
Problem with PostgreSQL !!! beyond_2000 Linux - Software 10 06-15-2004 06:46 AM
Postgresql problem BobNz Linux - Software 11 05-02-2004 02:43 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM


All times are GMT -5. The time now is 02:32 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration