PGSQL 8.0.1 Win 2K Installation Problem

Started by S.D.about 21 years ago10 messagesgeneral
Jump to latest
#1S.D.
sdownie@myway.com

I downloaded the native Windows 8.0.1 installer and sorted through the various Windows permissions problems by running the Installer as an admin but not creating a cluster. Then I log out and log back in as the limited "postgres" user and run initdb.exe from the command line. Initdb creates the data folder and everything seems to be going well until just after "initializing pg_depend ... ok". The next lines are:

-----
creating system views ... FATAL: unrecognized node type: 653
child process was terminated by signal 1
initdb: removing contents of data directory
-----

What am I doing wrong? This installation is on Windows 2000 Pro running inside Virtual PC 6 on the Macintosh (10.3.8). I've searched all over the web but have found nothing that refers to this error code.

Any help would be appreciated!

Thanks!

Scott

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: S.D. (#1)
Re: PGSQL 8.0.1 Win 2K Installation Problem

"S.D." <sdownie@myway.com> writes:

I downloaded the native Windows 8.0.1 installer and sorted through the various Windows permissions problems by running the Installer as an admin but not creating a cluster. Then I log out and log back in as the limited "postgres" user and run initdb.exe from the command line. Initdb creates the data folder and everything seems to be going well until just after "initializing pg_depend ... ok". The next lines are:

-----
creating system views ... FATAL: unrecognized node type: 653

You seem to have a miscompiled backend. Where did you get the installer
from? Maybe a bad download?

regards, tom lane

#3S.D.
sdownie@myway.com
In reply to: Tom Lane (#2)
Re: PGSQL 8.0.1 Win 2K Installation Problem

Tom suggested:

You seem to have a miscompiled backend. Where did you get the
installer from? Maybe a bad download?

I snagged the non-Japanese version from:

http://www.postgresql.org/ftp/win32/

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com

#4S.D.
sdownie@myway.com
In reply to: S.D. (#3)
Re: PGSQL 8.0.1 Win 2K Installation Problem

I downloaded the PostGreSQL Windows installer from another FTP site but I still ended up with the same arcane error message when I tried to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6 (Macintosh).

I then ran the installer on a "real" computer (Athlon 1900 running W2K) and the installation went as advertised.

So I've got to believe that there is some bug that results from the interaction of the PostGreSQL installer and the chip set emulated by Virtual PC 6. If I'm the first person to attempt to install PostGreSQL 8.0.1 in that environment, then I guess this is a bug report. :-)

Thanks!

Scott

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com

#5Jonel Rienton
jonel@road14.com
In reply to: S.D. (#4)
Re: PGSQL 8.0.1 Win 2K Installation Problem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

just to let you know, i got the same error message when i tried it on
my win2k inistall emulated by Virtual PC 7.

- -----
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 19, 2005, at 1:14 PM, S.D. wrote:

I downloaded the PostGreSQL Windows installer from another FTP site
but I still ended up with the same arcane error message when I tried
to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6
(Macintosh).

I then ran the installer on a "real" computer (Athlon 1900 running
W2K) and the installation went as advertised.

So I've got to believe that there is some bug that results from the
interaction of the PostGreSQL installer and the chip set emulated by
Virtual PC 6. If I'm the first person to attempt to install PostGreSQL
8.0.1 in that environment, then I guess this is a bug report. :-)

Thanks!

Scott

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com

---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

-----BEGIN PGP SIGNATURE-----
Version: PGP 8.1

iQA/AwUBQhfDEOAwOVAnbsGCEQKhvACdF5B5qdIoI0Em2F9RSwb0WvPNFeAAoPSQ
8li8cwOaP6kHrbdktvR+1jHL
=3lPx
-----END PGP SIGNATURE-----

#6John DeSoi
desoi@pgedit.com
In reply to: S.D. (#4)
Re: PGSQL 8.0.1 Win 2K Installation Problem

On Feb 19, 2005, at 2:14 PM, S.D. wrote:

I downloaded the PostGreSQL Windows installer from another FTP site
but I still ended up with the same arcane error message when I tried
to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6
(Macintosh).

Does Virtual PC 6 really emulate NTFS drives?

Just curious: why would you want to use Virtual PC/Windows rather than
native PostgreSQL on OS X?

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

#7Doug McNaught
doug@mcnaught.org
In reply to: John DeSoi (#6)
Re: PGSQL 8.0.1 Win 2K Installation Problem

John DeSoi <desoi@pgedit.com> writes:

On Feb 19, 2005, at 2:14 PM, S.D. wrote:

I downloaded the PostGreSQL Windows installer from another FTP site
but I still ended up with the same arcane error message when I tried
to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6
(Macintosh).

Does Virtual PC 6 really emulate NTFS drives?

It emulates an IDE disk--the Microsoft NTFS driver runs on the virtual
machine and talks to the emulated disk.

Just curious: why would you want to use Virtual PC/Windows rather than
native PostgreSQL on OS X?

A very good question indeed. :)

-Doug

#8Tom Lane
tgl@sss.pgh.pa.us
In reply to: S.D. (#4)
Re: PGSQL 8.0.1 Win 2K Installation Problem

"S.D." <sdownie@myway.com> writes:

I downloaded the PostGreSQL Windows installer from another FTP site but I still ended up with the same arcane error message when I tried to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6 (Macintosh).

I then ran the installer on a "real" computer (Athlon 1900 running W2K) and the installation went as advertised.

So I've got to believe that there is some bug that results from the interaction of the PostGreSQL installer and the chip set emulated by Virtual PC 6. If I'm the first person to attempt to install PostGreSQL 8.0.1 in that environment, then I guess this is a bug report. :-)

I think you're reporting to the wrong place ;-). If Virtual PC fails to
act like a real PC, it's not the fault of the application that exposed
the deficiency in their emulation.

regards, tom lane

#9Magnus Hagander
magnus@hagander.net
In reply to: Tom Lane (#8)
Re: PGSQL 8.0.1 Win 2K Installation Problem

I assume this is also VirtuaL PC on the mac, right? I've been using
VirtualPC on the PC for a lot of th dev work on the intaller, and it
should certaily work there..

Does this only occur with win2k, or does it also occur with
XP/2003/whatever?

In the end I doubt there is much we can do, it seems to be an issue of
Virtual PC not being close enough to a PC.

//Magnus

Show quoted text

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jonel Rienton
Sent: den 20 februari 2005 00:52
To: postgres list
Cc: sdownie@myway.com
Subject: Re: [GENERAL] PGSQL 8.0.1 Win 2K Installation Problem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

just to let you know, i got the same error message when i tried it on
my win2k inistall emulated by Virtual PC 7.

- -----
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 19, 2005, at 1:14 PM, S.D. wrote:

I downloaded the PostGreSQL Windows installer from another FTP site
but I still ended up with the same arcane error message when I tried
to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6
(Macintosh).

I then ran the installer on a "real" computer (Athlon 1900 running
W2K) and the installation went as advertised.

So I've got to believe that there is some bug that results from the
interaction of the PostGreSQL installer and the chip set emulated by
Virtual PC 6. If I'm the first person to attempt to install

PostGreSQL

8.0.1 in that environment, then I guess this is a bug report. :-)

Thanks!

Scott

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com

---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

-----BEGIN PGP SIGNATURE-----
Version: PGP 8.1

iQA/AwUBQhfDEOAwOVAnbsGCEQKhvACdF5B5qdIoI0Em2F9RSwb0WvPNFeAAoPSQ
8li8cwOaP6kHrbdktvR+1jHL
=3lPx
-----END PGP SIGNATURE-----

---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#10Jonel Rienton
jonel@road14.com
In reply to: Magnus Hagander (#9)
Re: PGSQL 8.0.1 Win 2K Installation Problem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I don't use PostgreSQL in Windows, I was just merely verifying that
this guy isn't the only one having this kind of problem, and yes this
is a Mac. I run my PostgreSQL db in Solaris, Linux and Mac OS X :-)

- -----
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 20, 2005, at 7:55 AM, Magnus Hagander wrote:

I assume this is also VirtuaL PC on the mac, right? I've been using
VirtualPC on the PC for a lot of th dev work on the intaller, and it
should certaily work there..

Does this only occur with win2k, or does it also occur with
XP/2003/whatever?

In the end I doubt there is much we can do, it seems to be an issue of
Virtual PC not being close enough to a PC.

//Magnus

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jonel Rienton
Sent: den 20 februari 2005 00:52
To: postgres list
Cc: sdownie@myway.com
Subject: Re: [GENERAL] PGSQL 8.0.1 Win 2K Installation Problem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

just to let you know, i got the same error message when i tried it on
my win2k inistall emulated by Virtual PC 7.

- -----
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 19, 2005, at 1:14 PM, S.D. wrote:

I downloaded the PostGreSQL Windows installer from another FTP site
but I still ended up with the same arcane error message when I tried
to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6
(Macintosh).

I then ran the installer on a "real" computer (Athlon 1900 running
W2K) and the installation went as advertised.

So I've got to believe that there is some bug that results from the
interaction of the PostGreSQL installer and the chip set emulated by
Virtual PC 6. If I'm the first person to attempt to install

PostGreSQL

8.0.1 in that environment, then I guess this is a bug report. :-)

Thanks!

Scott

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com

---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

-----BEGIN PGP SIGNATURE-----
Version: PGP 8.1

iQA/AwUBQhfDEOAwOVAnbsGCEQKhvACdF5B5qdIoI0Em2F9RSwb0WvPNFeAAoPSQ
8li8cwOaP6kHrbdktvR+1jHL
=3lPx
-----END PGP SIGNATURE-----

---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

-----BEGIN PGP SIGNATURE-----
Version: PGP 8.1

iQA/AwUBQhjn6uAwOVAnbsGCEQLUeQCgkajNfukpDcf3PesuVqdx+ZY3l4sAoI5z
y43esiFzrXhTrlIxiMGBmzqB
=SWWQ
-----END PGP SIGNATURE-----