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. |
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 |
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. |