postgresql problem

idrissess · 08-01-2010, 08:47 AM

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.

Tinkster · 08-01-2010, 11:36 PM

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

Aquarius_Girl · 08-02-2010, 12:14 AM

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