LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   postgresql problem (https://www.linuxquestions.org/questions/linux-newbie-8/postgresql-problem-823379/)

idrissess 08-01-2010 08:47 AM

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.

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


All times are GMT -5. The time now is 05:56 AM.