Cant su - postgres

stevengoodman · 2010-09-09 09:14:02

Hi Guys,

I've had a server setup working perfectly for the last 2 years. Today we installed a newer version of postgresql and recompiled apache/php.

Postgresql will not start now.

"service postgresql start" = /var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first.

To initdb we need to be as user postgres.

"su - postgres" = "no file or directory"

In /etc/passwd = postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash

Any ideas as to how i can login as postgres user and enter these commands?

igndenok · 2010-09-09 10:19:35

Try running

# su - postgres

again, but run it as root.
I can use postgres user after running that as root, not as my user.

stevengoodman · 2010-09-09 10:20:28

root@dedicated [/home]# su - postgres
: No such file or directory

marxav · 2010-09-09 16:08:35

Did you stop your postgres server first? If you did not upgrade for two years, obvisouly this is an issue of "major release" upgrade. That is internal structure of tables changed between releases and are not backward compatible basically.

stevengoodman · 2010-09-10 04:18:47

I dont need any of the databases. I just need postgresql running again. postgres was stopped prior to upgrading yes. It was uninstalled and then the new package installed.

tomk · 2010-09-10 06:18:37

"service postgresql start"... that command doesn't work on Arch. I think you should be talking to people who use the same distro as you.

Arch Linux

#1 2010-09-09 09:14:02

Cant su - postgres

#2 2010-09-09 10:19:35

Re: Cant su - postgres

#3 2010-09-09 10:20:28

Re: Cant su - postgres

#4 2010-09-09 16:08:35

Re: Cant su - postgres

#5 2010-09-10 04:18:47

Re: Cant su - postgres

#6 2010-09-10 06:18:37

Re: Cant su - postgres

Board footer