Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: roll back t...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 8 of 8 Topic 15983 of 17437
Post > Topic >>

Re: roll back to 8.1 for PyQt driver work-around

by lennin.caro@[EMAIL PROTECTED] (Lennin Caro) Jul 7, 2008 at 07:08 AM

sound like you have a postmaster.pid in your PGDATA directory. Rename file
postmaster.pid and launch the postgresql again

--- On Sat, 7/5/08, Scott Frankel <frankel@[EMAIL PROTECTED]
> wrote:

> From: Scott Frankel <frankel@[EMAIL PROTECTED]
>
> Subject: [GENERAL] roll back to 8.1 for PyQt driver work-around
> To: "PostgreSQL List" <pgsql-general@[EMAIL PROTECTED]
>
> Date: Saturday, July 5, 2008, 11:40 PM
> Hello, I just signed on the list.
> 
> Any suggestions for how best to launch one of two different
> versions  
> of pg installed on the same machine?
> 
> I have both 8.3 and 8.1 installed on a MacBookPro (OS X
> 10.5.2).  I  
> stopped the 8.3 postmaster using pg_ctl in order to roll
> back to 8.1.   
> Problem is, now I can't seem to start the server using
> either version.
> 
> When I launch 8.1 with pg_ctl, it yields a "postmaster
> starting"  
> message; but then a status check shows that the server is
> not  
> running.  Issuing the same commands for 8.3, I get similar
> results.
> 
> eg:
> 
> [tiento:~] postgres% /opt/local/lib/postgresql81/bin/pg_ctl
> start -D / 
> Library/PostgreSQL8/data -l /Users/Shared/pgLog/pgLog.txt
> postmaster starting
> 
> [tiento:~] postgres% /opt/local/lib/postgresql81/bin/pg_ctl
> status -D / 
> Library/PostgreSQL8/data
> pg_ctl: neither postmaster nor postgres running
> 
> 
> I'm trying to roll back to version 8.1 as I've run
> into a bug in Qt's  
> QPSQL driver.  I'm able to create tables and add rows
> of data to them;  
> but my model.select() statements all fail.  The "This
> version of  
> PostgreSQL is not sup****ted and may not work" message
> is ominous ;)
> 
> Thanks in advance!
> Scott
> 
> 
> 
> 
> 
> Scott Frankel
> President/VFX Supervisor
> Circle-S Studios
> 510-339-7477 (o)
> 510-332-2990 (c)
> 
> 
> 
> 
> 
> -- 
> Sent via pgsql-general mailing list
> (pgsql-general@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


      


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 8 Posts in Topic:
roll back to 8.1 for PyQt driver work-around
frankel@[EMAIL PROTECTED]  2008-07-05 16:40:18 
Re: roll back to 8.1 for PyQt driver work-around
tgl@[EMAIL PROTECTED] (T  2008-07-06 01:43:43 
Re: roll back to 8.1 for PyQt driver work-around
frankel@[EMAIL PROTECTED]  2008-07-06 09:19:41 
Re: roll back to 8.1 for PyQt driver work-around
tgl@[EMAIL PROTECTED] (T  2008-07-06 13:48:56 
Re: roll back to 8.1 for PyQt driver work-around
frankel@[EMAIL PROTECTED]  2008-07-06 22:46:32 
Re: roll back to 8.1 for PyQt driver work-around
alvherre@[EMAIL PROTECTED  2008-07-07 09:39:18 
Re: roll back to 8.1 for PyQt driver work-around
guillaume@[EMAIL PROTECTE  2008-07-16 16:52:44 
Re: roll back to 8.1 for PyQt driver work-around
lennin.caro@[EMAIL PROTEC  2008-07-07 07:08:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 16:15:15 CST 2008.