Fedora Linux Support Community & Resources Center

Go Back   FedoraForum.org > Fedora 17/18 > Using Fedora
FedoraForum Search

Forgot Password? Join Us!

Using Fedora General support for current versions. Ask questions about Fedora and it's software that do not belong in any other forum.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 9th November 2011, 03:22 PM
saeru Offline
Registered User
 
Join Date: Dec 2008
Posts: 13
windows_xp_2003firefox
postgresql-setup upgrade problem in fc16

Finlay after Yum upgrade FC15 -> FC16 , I can't upgrade database

#postgresql-setup upgrade
Redirecting to /bin/systemctl stop postgresql.service
Upgrading database: failed

See /var/lib/pgsql/pgupgrade.log for details.


This is IT,
[root@stend pgsql]# cat /var/lib/pgsql/pgupgrade.log
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions ok

connection to database failed: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


unable to connect to old postmaster started with the command: "/usr/lib/pgsql/postgresql-9.0/bin/pg_ctl" -w -l "/dev/null" -D "/var/lib/pgsql/data-old" -o "-p 5432 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000" start >> "/dev/null" 2>&1
Failure, exiting


Any Idea?

Last edited by saeru; 10th November 2011 at 05:46 AM.
Reply With Quote
  #2  
Old 9th November 2011, 04:28 PM
vasile002 Offline
Registered User
 
Join Date: Oct 2011
Posts: 52
windows_7firefox
Re: postgresql-setup upgrade problem in fc16

Is postgres running when you run the upgrade command? You need to start the old postgres first

fedora development

Last edited by vasile002; 6th October 2012 at 04:48 AM.
Reply With Quote
  #3  
Old 9th November 2011, 06:51 PM
saeru Offline
Registered User
 
Join Date: Dec 2008
Posts: 13
windows_xp_2003firefox
Re: postgresql-setup upgrade problem in fc16

Nothing is started, postgresql-setup upgrade copy old data dir to data-old, then run old and new pgsql together. But can't connect to chem later. This problem affected in FC16 only, previous upgrades was not have any error.

Steel no result

Last edited by saeru; 13th November 2011 at 12:21 PM.
Reply With Quote
  #4  
Old 1st December 2011, 02:33 PM
saeru Offline
Registered User
 
Join Date: Dec 2008
Posts: 13
macosfirefox
Re: postgresql-setup upgrade problem in fc16

Solved in latest update!

Last edited by saeru; 17th December 2011 at 06:42 AM.
Reply With Quote
Reply

Tags
fc16, postgresqlsetup, problem, upgrade

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem wiyh last kernel 3.0.0-1.fc16.x86_64 chepioq F16 Development 3 2nd August 2011 09:15 PM
Postgresql setup problems for metasploit FlyingTriangle Using Fedora 1 10th January 2011 05:44 PM
How to setup pgAdmin III with postgreSQL? Monyet Using Fedora 0 31st March 2008 02:47 AM
PostGreSQL 8.1.4 Initial Setup and Config Tutorial eengnerd Using Fedora 0 2nd August 2006 11:52 PM
[Q] FC4 - PostgreSQL Data Upgrade TheEdge Servers & Networking 0 28th June 2005 11:17 AM


Current GMT-time: 00:48 (Tuesday, 21-05-2013)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat