Re: postgresql upgrade from sarge to etch

2007-07-10 Thread Roberto C . Sánchez
On Tue, Jul 10, 2007 at 11:49:33PM -0400, Tony Heal wrote: > > Yes the file was there. This was in fact a complete running systems with no > problems. Postgresql was running with 2 > small databases and 2 users. > Then I am not sure. Perhaps a misbehaving preinst or postinst script? Regards,

RE: postgresql upgrade from sarge to etch

2007-07-10 Thread Tony Heal
TECTED] > Sent: Tuesday, July 10, 2007 6:40 PM > To: debian-user@lists.debian.org > Subject: Re: postgresql upgrade from sarge to etch > > On Tue, Jul 10, 2007 at 05:41:35PM -0400, Tony Heal wrote: > > I am trying to upgrade from sarge to etch and having issues with > >

Re: postgresql upgrade from sarge to etch

2007-07-10 Thread Roberto C . Sánchez
On Tue, Jul 10, 2007 at 05:41:35PM -0400, Tony Heal wrote: > I am trying to upgrade from sarge to etch and having issues with postgresql. > Here is the error on the screen, but I am > getting nothing in /var/log/dpkg.log or the syslog > > > > Setting up postgresql-client (7.5.22) ... > > Sett

Re: postgresql upgrade

2007-04-18 Thread Michelle Konzack
Am 2007-04-10 05:49:31, schrieb Tom Allison: > I have a "munged" database path that i put together so that my database > could run on a software raid array (linear, and don't tell me about how > "bad" this is). > > I never got it working 100% because I kept getting an error about invalid > pidf

Re: postgresql upgrade: cannot start postmaster

2004-10-29 Thread debian-throwaway1
Replying to myself: previous e-mail archived at http://lists.debian.org/debian-user/2004/10/msg03246.html Digging around, I've tracked down the messages about stopping postgresql to /etc/init.d/postgresql, which is called by the prerm and preinst scripts. The problem would seem to be that /etc

Re: Postgresql upgrade!!!!

2004-10-05 Thread Katipo
Andrea Vettorello wrote: On Tue, 5 Oct 2004 10:44:48 -0700 (PDT), D S <[EMAIL PROTECTED]> wrote: Does anybody knows how to upgrade postgresql on Debian manually or by apt-get? The debian security web site has only the old 7.2 version. I tried to load it form other http sources but it can't fin

Re: Postgresql upgrade!!!!

2004-10-05 Thread Andrea Vettorello
On Tue, 5 Oct 2004 10:44:48 -0700 (PDT), D S <[EMAIL PROTECTED]> wrote: > > Does anybody knows how to upgrade postgresql on Debian manually or by > apt-get? > The debian security web site has only the old 7.2 version. > I tried to load it form other http sources but it can't find it. > I need u

Re: PostgreSQL upgrade (7.3->7.4) failed: need a up to date dump

2004-02-23 Thread Cinly Ooi
Dear Oliver, I did that using dpkg-reconfigure postgresql ()Where should the PostgreSQL database be created? [default taken] () Should the data be purged as well as the package files? yes {since I have the dump file, its ok to purge everything} :-) What character encoding should the database use

Re: PostgreSQL upgrade (7.3->7.4) failed: need a up to date dump

2004-02-23 Thread Oliver Elphick
On Mon, 2004-02-23 at 17:23, Cinly Ooi wrote: > Dear Oliver, > > Thanks for the info. I checked the bug report. I had reinstalled 7.3.4 > and try upgrading again but the same message reappear, anyway around > this? I really need 7.4 running because one of the software uses 7.4. If you have made

Re: PostgreSQL upgrade (7.3->7.4) failed: need a up to date dump

2004-02-23 Thread Cinly Ooi
Dear Oliver, Thanks for the info. I checked the bug report. I had reinstalled 7.3.4 and try upgrading again but the same message reappear, anyway around this? I really need 7.4 running because one of the software uses 7.4. Many thanks, Cinly Oliver Elphick wrote: On Mon, 2004-02-23 at 16:55, C

Re: PostgreSQL upgrade (7.3->7.4) failed: need a up to date dump

2004-02-23 Thread Oliver Elphick
On Mon, 2004-02-23 at 16:55, Cinly Ooi wrote: > Dear all, > > While trying to upgrade from 7.3->7.4, I cannot get around the problem of > "You must have an up to date dump before upgrading to PostgreSQL 7.4" > eventhough I tried pg_dumpall > dumpfile See bug #230681 -- To UNSUBSCRIBE, email

Re: postgresql upgrade problem

2002-03-07 Thread Charles Baker
--- Oliver Elphick wrote: > On Thu, 2002-03-07 at 01:41, Charles Baker wrote: > ... > > Well, I just did an ``apt-get install > > postgresql-client'' and it caused many supporting > > packages to be installed including postgresql. Is > this > > indicative of a dependancy problem for these > packa

Re: postgresql upgrade problem

2002-03-07 Thread Oliver Elphick
On Thu, 2002-03-07 at 01:41, Charles Baker wrote: ... > Well, I just did an ``apt-get install > postgresql-client'' and it caused many supporting > packages to be installed including postgresql. Is this > indicative of a dependancy problem for these packages? Did it cause the removal of any packag

Re: Postgresql upgrade 7.1 -> 7.2 issue

2002-03-07 Thread Oliver Elphick
On Thu, 2002-03-07 at 00:17, [EMAIL PROTECTED] wrote: > I'm having problems upgrading from postgresql 7.1 to 7.2. > > On attempting to start the postmaster I get: > > # /etc/init.d/postgresql start > The database is in an older format that cannot be read by > version 7.2 of PostgreSQL. > > The p

Re: postgresql upgrade problem

2002-03-06 Thread Charles Baker
--- Charles Baker <[EMAIL PROTECTED]> wrote: > After postgresql was kept back on both an upgrade > and > a dist-upgrade, I tried an install. This is the > result: > > twin:/etc/apt# apt-get install postgresql > Reading Package Lists... Done > Building Dependency Tree... Done > Some packages could

Re: postgresql upgrade/downgrade: the data is BACK! but...

2001-02-28 Thread Oliver Elphick
will trillich wrote: >On Wed, Feb 28, 2001 at 06:52:01AM +, Oliver Elphick wrote: >> A pity the dump file got clobbered. > >indeed! > >> I suspect the dump from 6.5 was >> in a form that 7.0 rejected - you had those two failed creates in the >> log. > >the problem was appare

Re: postgresql upgrade/downgrade -- help!

2001-02-28 Thread Oliver Elphick
will trillich wrote: >> >-rw---1 postgres postgres 8192 Feb 27 04:00 range >> >-rw---1 postgres postgres16384 Feb 11 07:39 range_pkey >> >actually, i think the 'range' table is the main one i need to >> >resurrect... everything else is gravy. >> >> What

Re: postgresql upgrade/downgrade -- help!

2001-02-28 Thread will trillich
Oliver Elphick wrote: > will trillich wrote: > >-rw---1 postgres postgres4 Feb 27 12:24 PG_VERSION > >-rw---1 postgres postgres0 Oct 13 21:05 active > >-rw---1 postgres postgres 8192 Feb 27 04:00 cust > >-rw---1 postgres postgres16384

Re: postgresql upgrade/downgrade -- a clue?

2001-02-27 Thread will trillich
Oliver Elphick wrote: > > will trillich wrote: > >aha. i found /var/lib/postgresql/data/automatic_update.log > >containing, among other things: > > > >[snip] > >You are now connected to database template1 as user will. > >CREATE DATABASE > >You are now connected to database puz as us

Re: postgresql upgrade/downgrade -- help!

2001-02-27 Thread Oliver Elphick
will trillich wrote: >i did > apt-get update && apt-get upgrade >like a idiot without any pg_dump, and version 7.0.3potato* installed >rather cleanly, and it said it could update the database formats >behind-the-scenes, so i said 'okie dokie'. > >when i did > psql -u puz >

Re: postgresql upgrade/downgrade -- a clue?

2001-02-27 Thread will trillich
Oliver Elphick wrote: > > will trillich wrote: > > > >i munged my sources.list to point to fundet.no for the latest > >potato-friendly postgresql DEB package, and upgraded via apt-get > >update && apt-get upgrade. > > > > > > > >it broke my databases, so i tried apt-get --purge rem

Re: postgresql upgrade/downgrade -- help!

2001-02-27 Thread will trillich
Oliver Elphick wrote: > > will trillich wrote: > > > >i munged my sources.list to point to fundet.no for the latest > >potato-friendly postgresql DEB package, and upgraded via apt-get > >update && apt-get upgrade. > > > > > > > >it broke my databases, so i tried apt-get --purge rem