Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 08-01-2010, 09:47 AM   #1
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"?

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

Last edited by idrissess; 08-01-2010 at 09:54 AM.
Old 08-02-2010, 12:36 AM   #2
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.

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


Last edited by Tinkster; 08-02-2010 at 12:45 AM. Reason: [edit]
Old 08-02-2010, 01:14 AM   #3
Senior Member
Registered: Dec 2008
Posts: 4,680
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:


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 07:45 AM
PostgreSQL Problem r0ck Slackware 8 11-26-2004 12:02 PM
Problem with PostgreSQL !!! beyond_2000 Linux - Software 10 06-15-2004 07:46 AM
Postgresql problem BobNz Linux - Software 11 05-02-2004 03:43 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 03:50 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 07:34 AM.

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