Re: [ADMIN] Migrating from 32 to 64 bit

2007-11-25 Thread Medi Montaseri
But theoretically speaking, 32 or 64-bit ness of the application (ie the postmaster server) should not influence the data types offered by a particular DB version. That is the semantics of data types and cpu-arch (register width, big endian, little endian, sparc, mips, x86), etc ) offered by a part

Re: [ADMIN] Error while compiling PostgreSQL with Java

2007-11-25 Thread Peter Eisentraut
Никоноров Григорий wrote: > I have a problem. I try to install PostgreSQL from source with java. I > Installed JDK, ANT properly but when i try to configure i have an error - > Warning.Ignored options - --with-java. Please help me ! PostgreSQL has no such option. You may be looking for the JDBC d

[ADMIN] Error while compiling PostgreSQL with Java

2007-11-25 Thread Никоноров Григорий
Hello! I have a problem. I try to install PostgreSQL from source with java. I Installed JDK, ANT properly but when i try to configure i have an error - Warning.Ignored options - --with-java. Please help me ! [EMAIL PROTECTED] /]# export|grep java declare -x JAVA_HOME="/usr/java/jdk1.6.0_03"

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Jeff Larsen wrote: >> Because a file system level backup is no good unless the database is >> stopped, or you are using PITR. > You are begging the question. If I enable WAL archiving, make a base backup > to a safe place, and my data center goes up

[ADMIN] Error while compiling PostgreSQL with Java

2007-11-25 Thread Никоноров Григорий
Hello! I have a problem. I try to install PostgreSQL from source with java. I Installed JDK, ANT properly but when i try to configure i have an error - Warning.Ignored options - --with-java. Please help me ! [EMAIL PROTECTED] /]# export|grep java declare -x JAVA_HOME="/usr/java/jdk1.6.0_03" decl

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Peter Eisentraut
Jeff Larsen wrote: > On Nov 25, 2007 8:24 AM, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > Why is it not allowed to call pg_start_backup when WAL archiving is off? > > Wouldn't this be useful as a discrete file system backup without PITR > > capability? > > Because a file system level backup is

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Jeff Larsen
On Nov 25, 2007 8:24 AM, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Why is it not allowed to call pg_start_backup when WAL archiving is off? > Wouldn't this be useful as a discrete file system backup without PITR > capability? Because a file system level backup is no good unless the database is

[ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Peter Eisentraut
Why is it not allowed to call pg_start_backup when WAL archiving is off? Wouldn't this be useful as a discrete file system backup without PITR capability? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP

Re: [ADMIN] Migrating from 32 to 64 bit

2007-11-25 Thread Hannes Dorbath
Laurent CARON wrote: > Question: > I'd like to know if it is possible (and wise) to just keep the > /var/lib/postgres.. directories from the old 32Bit server to use on > the 64Bit version. > > This is just as a personal interest since I can also just dump and > restore the database in about 2.

Re: [ADMIN] Migrating from 32 to 64 bit

2007-11-25 Thread Hannes Dorbath
Laurent CARON wrote: > Question: > I'd like to know if it is possible (and wise) to just keep the > /var/lib/postgres.. directories from the old 32Bit server to use on > the 64Bit version. > > This is just as a personal interest since I can also just dump and > restore the database in about 2.