Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Bruce Momjian
Thomas Kellerer wrote: > Bruce Momjian wrote on 22.04.2009 20:26: > > Yes, I can confirm I think pg_migrator will work for 8.3->8.4 upgrades; > > I start testing this week. > > > This is pretty good news, cool. > > Will there be Windows binaries for the pg_migrator once that 8.4 ships? Uh, no i

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Dave Page
On Wed, Apr 22, 2009 at 7:54 PM, Thomas Kellerer wrote: > I still wonder why the one-click installer is so much more prominent than > the pginstaller. Because it was designed to remove many of the complexities of the MSI installer that most users don't need and many don't understand if they're n

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Thomas Kellerer
Bruce Momjian wrote on 22.04.2009 20:26: Yes, I can confirm I think pg_migrator will work for 8.3->8.4 upgrades; I start testing this week. This is pretty good news, cool. Will there be Windows binaries for the pg_migrator once that 8.4 ships? Thomas -- Sent via pgsql-general mailing list

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Thomas Kellerer
Raymond O'Donnell wrote on 22.04.2009 20:14: On 22/04/2009 19:05, Christine Penner wrote: It was a zip file with an msi installer in it. I tried to find a similar one for the update but all I could find was the one click installer. The initial installation sounds like it was the pgInstaller, s

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Christine Penner
Looks like that's the one I got last time. They must have had that one list on the main download page when I did the original install. I wouldn't have looked in the ftp section. Also when I looked in the ftp section earlier today, I skipped the binary stuff because the one click installer I go

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Raymond O'Donnell
On 22/04/2009 19:21, Christine Penner wrote: > The link below takes me to the same place I got this installer I'm > having problems with. I am pretty sure I got the original installer from Well, there are two installers listed there (at least, that's what I see): * One-click installer, on Enterpr

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Bruce Momjian
Tom Lane wrote: > "Joshua D. Drake" writes: > > RedHat/Cent/Fedora has long used the incorrect default of floating based > > timestamps. > > Josh, you're being extremely unhelpful by presenting the problem in > this narrow minded "correct" vs "incorrect" way. > > I'm going to go on the record no

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Christine Penner
The link below takes me to the same place I got this installer I'm having problems with. I am pretty sure I got the original installer from the Postgres web site just like I just did. Christine At 11:14 AM 22/04/2009, you wrote: On 22/04/2009 19:05, Christine Penner wrote: > It was a zip file

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Raymond O'Donnell
On 22/04/2009 19:05, Christine Penner wrote: > It was a zip file with an msi installer in it. I tried to find a similar > one for the update but all I could find was the one click installer. The initial installation sounds like it was the pgInstaller, so. It would be worth trying again with the sa

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Tom Lane
"Joshua D. Drake" writes: > RedHat/Cent/Fedora has long used the incorrect default of floating based > timestamps. Josh, you're being extremely unhelpful by presenting the problem in this narrow minded "correct" vs "incorrect" way. I'm going to go on the record now that if Bruce gets pg_migrator

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Tom Lane
Christine Penner writes: > Windows XP pro. I went to the postgres web site, downloads, clicked > on the binary package and selected windows. It gave me a file called > Postgresql-8.3.7-1-windows.exe There are different people distributing Postgres-for-Windows with different build options. You

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Christine Penner
It was a zip file with an msi installer in it. I tried to find a similar one for the update but all I could find was the one click installer. Christine At 11:00 AM 22/04/2009, you wrote: Joshua D. Drake wrote on 22.04.2009 19:34: Huh, I wonder when the windows package changed its defaults.

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Raymond O'Donnell
On 22/04/2009 19:00, Thomas Kellerer wrote: > Could it be that Christine initially installed the pginstaller version, > and now downloaded the EnterpriseDB installer? And EnterpriseDB compiles > with a different default setting? > > As far as I recall the .exe is the EnterpriseDB One-Click-Instal

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Thomas Kellerer
Joshua D. Drake wrote on 22.04.2009 19:34: Huh, I wonder when the windows package changed its defaults. Could it be that Christine initially installed the pginstaller version, and now downloaded the EnterpriseDB installer? And EnterpriseDB compiles with a different default setting? As far a

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Joshua D. Drake
On Wed, 2009-04-22 at 10:31 -0700, Christine Penner wrote: > Windows XP pro. I went to the postgres web site, downloads, clicked > on the binary package and selected windows. It gave me a file called > Postgresql-8.3.7-1-windows.exe > > When I run that I hit next for the postgres directory, then

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Christine Penner
Windows XP pro. I went to the postgres web site, downloads, clicked on the binary package and selected windows. It gave me a file called Postgresql-8.3.7-1-windows.exe When I run that I hit next for the postgres directory, then after hitting next for the data directory I get the error. I kept

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Joshua D. Drake
On Wed, 2009-04-22 at 10:13 -0700, Christine Penner wrote: > I am upgrading from 8.3.4 to 8.3.7. That's why I'm confused. The > notes said I wouldn't have to do that. 8.3.4 was the original install. What OS are you running? How did you go about upgrading? Debian/Ubuntu will use --integer-datetim

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Raymond O'Donnell
On 22/04/2009 18:12, Joshua D. Drake wrote: > On Wed, 2009-04-22 at 18:09 +0100, Raymond O'Donnell wrote: >> It sounds as if you're trying to get a later-version server to use an >> earlier-version data directory - this won't work. > > Actually the error is about whether or not the server was com

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Christine Penner
I am upgrading from 8.3.4 to 8.3.7. That's why I'm confused. The notes said I wouldn't have to do that. 8.3.4 was the original install. Christine At 10:09 AM 22/04/2009, you wrote: On 22/04/2009 16:57, Christine Penner wrote: > The existing data directory (Date/time settings: floating -point

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Joshua D. Drake
On Wed, 2009-04-22 at 18:09 +0100, Raymond O'Donnell wrote: > On 22/04/2009 16:57, Christine Penner wrote: > > > The existing data directory (Date/time settings: floating -point > > numbers) is not compatible with this server (Date/Time setting: 64-bit > > integers) > > > > I saw a few posts abou

Re: [GENERAL] Error installing Postgres

2009-04-22 Thread Raymond O'Donnell
On 22/04/2009 16:57, Christine Penner wrote: > The existing data directory (Date/time settings: floating -point > numbers) is not compatible with this server (Date/Time setting: 64-bit > integers) > > I saw a few posts about this but I'm still not sure how to fix it. I > think one of them said I

[GENERAL] Error installing Postgres

2009-04-22 Thread Christine Penner
When trying to upgrade Postgres I got this message: The existing data directory (Date/time settings: floating -point numbers) is not compatible with this server (Date/Time setting: 64-bit integers) I saw a few posts about this but I'm still not sure how to fix it. I think one of them said I

[GENERAL] Error Installing postgres 8.2.4 on Windows Server 2003 64bit

2007-08-23 Thread Peck, Brian
Hey all, When I try and install form the msi installer for version 8.2.4 I get the following error. Failed to run initdb: 128! And when it tells me to see the logfile for details, there is no log file in the tmp directory. Anyone know why it's doing this? It crashes furring the