[Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

ejmarkow · 2010-10-27 22:09:09

After upgrading to postgresql 9.0.1-2 & postgresql-libs 9.0.1-2, upon shutdown, the following message is displayed:

> Initiating Shutdown...
:: Stopping KDE Desktop Manager                                                                   [DONE]
:: Stopping MySQL Server                                                                          [DONE]
:: Stopping PostgreSQL                                                                            [BUSY]
pg_ctl: PID file "/var/lib/postgres/data/postmaster.pid" does not exist
Is server running?                                                                                [FAIL]
:: Stopping ALSA Levels                                                                           [DONE]
.
.
.

Note: When booting up, the PostgreSQL server starts up successfully.

Last edited by ejmarkow (2010-10-28 10:36:07)

toofishes · 2010-10-27 22:32:08

If you upgraded postgresql without doing a dump and restore, good luck to you. Know how your packages work.

ejmarkow · 2010-10-28 08:20:49

toofishes wrote:

If you upgraded postgresql without doing a dump and restore, good luck to you. Know how your packages work.

@toofishes: I know quite well how my packages work. It's just I never saw this before when upgrading PostgreSQL and not having to use dump or restore.

toffyrn · 2010-10-28 10:07:53

From http://www.postgresql.org/docs/9.0/static/release-9-0

E.2.2. Migration to Version 9.0
A dump/restore using pg_dump, or use of pg_upgrade, is required for those wishing to migrate data from any previous release.
Version 9.0 contains a number of changes that selectively break backwards compatibility in order to support new features and code quality improvements. In particular, users who make extensive use of PL/pgSQL, Point-In-Time Recovery (PITR), or Warm Standby should test their applications because of slight user-visible changes in those areas. Observe the following incompatibilities:

....

Are your data still there?

ejmarkow · 2010-10-28 10:35:26

toffyrn wrote:

From http://www.postgresql.org/docs/9.0/static/release-9-0
E.2.2. Migration to Version 9.0
A dump/restore using pg_dump, or use of pg_upgrade, is required for those wishing to migrate data from any previous release.
Version 9.0 contains a number of changes that selectively break backwards compatibility in order to support new features and code quality improvements. In particular, users who make extensive use of PL/pgSQL, Point-In-Time Recovery (PITR), or Warm Standby should test their applications because of slight user-visible changes in those areas. Observe the following incompatibilities:
....
Are your data still there?

@toffryn: Thanks for this migration info. That explains it all. Since I didn't have any crucial data to begin with, I simply uninstalled PostgreSQL, removed the directory /var/lib/postgres/ and all related files, and reinstalled it. Works fine. Thanks.

toffyrn · 2010-10-28 15:56:22

No problem... just remember to look for similar information next time you upgrade postgresql, it has never been "upgrade-safe"...

(therefore: Know how your packages work.)

Carlwill · 2010-11-01 16:42:40

Guys - I blindly upgraded and didn't do a dump / restore. Is my data gone? Is there a way to get it back?

foutrelis · 2010-11-01 16:55:41

Carlwill wrote:

Guys - I blindly upgraded and didn't do a dump / restore. Is my data gone? Is there a way to get it back?

Downgrade to postgresql 8.4.4-6, create a dump of your databases, upgrade to postgresql 9.0.1 again and restore. After you have your dump file, you might have to take a backup of the /var/lib/postgres directory and then delete it, before postgresql 9 will start.

Carlwill · 2010-11-01 17:34:00

Thank you so much for that URL. I got my data back. Lesson learned. Always BACK YOUR SH** UP!!!

dedanna1029 · 2010-11-01 19:48:32

I've successfully just downgraded:

# pacman -U /var/cache/pacman/pkg/postgresql-8.4.4-6-i686.pkg.tar.xz
resolving dependencies...
looking for inter-conflicts...

Targets (1): postgresql-8.4.4-6 [3.78 MB]

Total Download Size:    0.00 MB
Total Installed Size:   21.31 MB

Proceed with installation? [Y/n] y
checking package integrity...
(1/1) checking for file conflicts                  [######################] 100%
(1/1) upgrading postgresql                         [######################] 100%

Think I'm going to stick with that.

toffyrn · 2010-11-01 19:58:02

Just remember that you cant stick with that forever... sooner or later you'll gonna need to upgrade

dedanna1029 · 2010-11-01 20:21:43

Yeah, I get that, but for now at least I have my db back. Until they find a smoother way to upgrade these things, then this needs to stay as-is, IMO.

dedanna1029 · 2011-01-22 16:29:55

I decided to start all over with postgresql, as I am to the point of having to upgrade whether I like it or not.

I renamed /var/lib/postgres to /var/lib/postgres.old, and uninstalled the old postgresql. I then installed the new postgresql, recreated my db, and then rebooted. It wouldn't start on boot, just stayed at [BUSY].

I then tried to start it manually once rebooted, and it failed:

# /etc/rc.d/postgresql start
:: Starting PostgreSQL                                                                                                                                [BUSY] pg_ctl: another server might be running; trying to start server anyway
pg_ctl: could not start server
Examine the log output.
                                                                                                                                                      [FAIL]

How do I get it to start?

/var/lib/postgresql.log just reflects:

LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  received smart shutdown request
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was shut down at 2011-01-22 10:14:38 MST
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 1492) running in data directory "/var/lib/postgres/data"?

I've run top, and htop both as root and regular user. It's not running at all.

I have 5 postgresql logs in /var/log:

ls /var/log | grep post
postgresql.log
postgresql.log.1
postgresql.log.2
postgresql.log.3
postgresql.log.4

Which one would be the latest? I'm assuming postgresql.log here.

Thanks.

Last edited by dedanna1029 (2011-01-22 17:31:24)

dedanna1029 · 2011-01-22 18:10:38

Yet I downgrade back to 8.4.4, put the old /var/lib/postgres back in place, reboot, and it's running fine.

Edit, have just tried again going through the steps at the Upgrading postgresql Arch wiki, and found I missed a step. Running fine now on the latest postgresql, thanks.

Last edited by dedanna1029 (2011-01-22 18:51:17)

Arch Linux

#1 2010-10-27 22:09:09

[Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#2 2010-10-27 22:32:08

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#3 2010-10-28 08:20:49

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#4 2010-10-28 10:07:53

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#5 2010-10-28 10:35:26

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#6 2010-10-28 15:56:22

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#7 2010-11-01 16:42:40

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#8 2010-11-01 16:55:41

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#9 2010-11-01 17:34:00

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#10 2010-11-01 19:48:32

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#11 2010-11-01 19:58:02

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#12 2010-11-01 20:21:43

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#13 2011-01-22 16:29:55

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

#14 2011-01-22 18:10:38

Re: [Solved] PostgreSQL & Libs 9.0.1-2 Issue: Doesn't Shutdown Properly

Board footer