Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Tom Lane
Francis Reed <[EMAIL PROTECTED]> writes: > We tested the principle with postgres 7.4.6 but found a what we believe is a > compile time dependancy in create_conversion.sql where $libdir is not being > resolved properly during the initdb process on the second machine. We only started supporting the

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Joshua D. Drake
Peter Eisentraut wrote: Francis Reed wrote: We tested the principle with postgres 7.4.6 but found a what we believe is a compile time dependancy in create_conversion.sql where $libdir is not being resolved properly during the initdb process on the second machine. The usual environment variables

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Peter Eisentraut
Francis Reed wrote: > We tested the principle with postgres 7.4.6 but found a what we > believe is a compile time dependancy in create_conversion.sql where > $libdir is not being resolved properly during the initdb process on > the second machine. The usual environment variables don't seem to > hel

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Richard Huxton
Francis Reed wrote: Hi Richard, Sun/Sparc is the platform of choice in our case. We tested the principle with postgres 7.4.6 but found a what we believe is a compile time dependancy in create_conversion.sql where $libdir is not being resolved properly during the intidb process. The usual environmen

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Doug McNaught
Francis Reed <[EMAIL PROTECTED]> writes: > If I want to create a postgres database on multiple machines, is the > practice of tarring or zipping up binaries compiled on one machine and > untarring them on another, and using the binaries (initdb etc) acceptable?. > This removes the need for having

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Francis Reed
em to help (LD_LIBRARY_PATH; PATH; PGLIB etc). Anyone come across that? Thx -Original Message- From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Sent: 24 November 2004 13:33 To: Francis Reed Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Moving/Using Postgres Binaries on mult

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Martijn van Oosterhout
Sure, this is what Linux distributers do. They compile postgresql into a binary package which is installed on the user's machine. It works as long as the environments are reasonably compatable, all have readline, similar libc, etc. Hope this helps, On Wed, Nov 24, 2004 at 12:30:28PM -, Franc

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

2004-11-24 Thread Richard Huxton
Francis Reed wrote: If I want to create a postgres database on multiple machines, is the practice of tarring or zipping up binaries compiled on one machine and untarring them on another, and using the binaries (initdb etc) acceptable?. This removes the need for having a compiler and environment on