Arch Linux

rozoweskarpetki

Member

Registered: 2008-05-12

Posts: 8

Postgresql breaks after the latest upgrade

The latest upgrade of Postgresql (to 8.3) seems to be broken. I now cannot connect to the database:

 could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

When I start it ( /etc/rc.d/postgresql start ) everything seems ok, but I can't stop it or restart it:

pg_ctl: PID file "/var/lib/postgres/data/postmaster.pid" does not exist
Is server running?

I googled, but have no idea what to do to fix the problem.

zakora

Member

Registered: 2008-05-12

Posts: 22

Re: Postgresql breaks after the latest upgrade

Same problem here (first time install), i have followed the arch wiki guide : http://wiki.archlinux.org/index.php/PostgreSQL .
I cannot create database.

Snowman

Developer/Forum Fellow

From: Montreal, Canada

Registered: 2004-08-20

Posts: 5,212

Re: Postgresql breaks after the latest upgrade

Please submit a bug report.

EDIT: BTW, are you using  8.3.0 or  8.3.1 ?

Snowman

Developer/Forum Fellow

From: Montreal, Canada

Registered: 2004-08-20

Posts: 5,212

Re: Postgresql breaks after the latest upgrade

Also are you on i686 or x86_64? Put that info in the bug report.

rozoweskarpetki

Member

Registered: 2008-05-12

Posts: 8

Re: Postgresql breaks after the latest upgrade

Right, I've added the bug report.
I'm using 8.3.1 on i686.

eldritch

Member

Registered: 2007-11-12

Posts: 3

Re: Postgresql breaks after the latest upgrade

After reading Snowman's reply in the bug report, I followed http://www.postgresql.org/docs/8.3/stat … ading.html and everything works fine again. I didn't try restoring my data, but hopefully their guide works. On a side note, if you're also using PostGIS, it needs to be upgraded to 1.3 to work with the new Postgresql.

Nicoco

Member

Registered: 2007-12-25

Posts: 19

Re: Postgresql breaks after the latest upgrade

Hi !

I didn't notice there was a postgresql update during my latest pacman -Syu, so I'm experiencing the same problem. Now that I have postgresql 8.3.1 installed, what is the right way to restore my database ? I can't use pg_dumpall, because I don't have postgresql 8.2 anymore.
Thanks for helping me, I really don't know where to start !

rozoweskarpetki

Member

Registered: 2008-05-12

Posts: 8

Re: Postgresql breaks after the latest upgrade

Thanks for all the help and explanations!

@Nicoco - you can downgrade the package (follow the guidelines here).

Nicoco

Member

Registered: 2007-12-25

Posts: 19

Re: Postgresql breaks after the latest upgrade

thanks !
"downgrading" was the keyword I couldn't find