Re: [ADMIN] Is there a way to build 32-bit mode on 64-bit Linux boxes?

2005-06-08 Thread Wayne Schroeder
I need to back up a bit and explain why I was hoping there was a better way to build everything as 32-bit. On a 64-bit Linux host, if I just try to build as usual, I get errors in my MCAT app since it is not 64-bit compatible yet. If I try to build everything (postgresql, odbc, and mcat) 32-bit, I

Re: [ADMIN] Indexes getting corrupted.

2005-06-08 Thread Scott Marlowe
On Wed, 2005-06-08 at 13:39, Bruno G. Albuquerque wrote: > I am having a weird problem here. I have the automated process to > install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing > the database server itself, my process does the following: > > 1 - Runs initdb to created the d

Re: [ADMIN] Indexes getting corrupted.

2005-06-08 Thread Tom Arthurs
Reindexdb in contrib should help with rebuilding indexes. Bruno G. Albuquerque wrote: I am having a weird problem here. I have the automated process to install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing the database server itself, my process does the following: 1 - Runs

Re: [ADMIN] Is there a way to build 32-bit mode on 64-bit Linux boxes?

2005-06-08 Thread Wayne Schroeder
Subject: Re: [ADMIN] Is there a way to build 32-bit mode on 64-bit Linux boxes? Date: Wed, 08 Jun 2005 11:34:42 -0700 From: Wayne Schroeder <[EMAIL PROTECTED]> To: AgentM <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Thanks for responding, everyone (Ross, Joshua, and Age

[ADMIN] Indexes getting corrupted.

2005-06-08 Thread Bruno G. Albuquerque
I am having a weird problem here. I have the automated process to install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing the database server itself, my process does the following: 1 - Runs initdb to created the database I will be using. 2 - Runs a SQL script that creates the

Re: [ADMIN] Is there a way to build 32-bit mode on 64-bit Linux boxes?

2005-06-08 Thread Mohan, Ross
I'm trying to build postgresql and odbc from source on x86_64 Linux hosts but I need to run them in 32-bit addressing mode since my app is not 64-bit ready yet. || I'm kinda new to this, but...unless your app is compiled and linked into PG shared objects, I don't think it'll care whether it

Re: [ADMIN] Is there a way to build 32-bit mode on 64-bit Linux boxes?

2005-06-08 Thread Joshua D. Drake
Wayne Schroeder wrote: I'm trying to build postgresql and odbc from source on x86_64 Linux hosts but I need to run them in 32-bit addressing mode since my app is not 64-bit ready yet. What does your app care? Unless you are writing the app directly to libpq? Which version of Linux are you runn

[ADMIN] Is there a way to build 32-bit mode on 64-bit Linux boxes?

2005-06-08 Thread Wayne Schroeder
I'm trying to build postgresql and odbc from source on x86_64 Linux hosts but I need to run them in 32-bit addressing mode since my app is not 64-bit ready yet. Simple test programs can be built as 32-bit apps (if the libraries are installed) via gcc's -m32 option. I checked for postgres configur

Re: [ADMIN] [Newbie] RedHat 7.2 & Postgresql 8

2005-06-08 Thread Devrim GUNDUZ
Hi, On Wed, 8 Jun 2005, Tom Lane wrote: I'd like to know if it's possible to install Postgresql v8 on a RedHat 7.2 ? If ok, can I use the binaries distrib ? the source distrib ? red hat or fedora ? Is the RedHat-9 rpms install is compatible ? I've been told that our current SRPMs will not b

Re: [ADMIN] [Newbie] RedHat 7.2 & Postgresql 8

2005-06-08 Thread Tom Lane
"robert.lamie" <[EMAIL PROTECTED]> writes: > I'd like to know if it's possible to install Postgresql v8 on > a RedHat 7.2 ? If ok, can I use the binaries distrib ? the > source distrib ? red hat or fedora ? Is the RedHat-9 rpms > install is compatible ? I've been told that our current SRPMs will

Re: [ADMIN] btree information

2005-06-08 Thread Alvaro Herrera
On Wed, Jun 08, 2005 at 07:04:17AM -0600, Eduardo Bezerra wrote: > Sorry, > > But, where can I find out this utility? Is it pg_dump? No, see in http://sources.redhat.com/rhdb or thereabouts (maybe http://sources.redhat.com/RHDB even, not sure) -- Alvaro Herrera () "Puedes vivir solo una vez, pe

Re: [ADMIN] btree information

2005-06-08 Thread Eduardo Bezerra
Sorry,    But, where can I find out this utility? Is it pg_dump?2005/6/7, Alvaro Herrera <[EMAIL PROTECTED] >:On Tue, Jun 07, 2005 at 01:36:56PM -0400, Eduardo Bezerra wrote:> hi all, >  Someone can help me to find these data about btree index:>   * height;>  * maximum number of keys per block>  *

[ADMIN] Schema diffs

2005-06-08 Thread Fredrik Olsson
Hello. I run a database on two separate servers, one development/test server and one production server. The production database is updated quite often, and the development database is naturally used to quality test changes before deployment. For small changes manual updates are no problem. For ma

Re: [ADMIN] [Newbie] RedHat 7.2 & Postgresql 8

2005-06-08 Thread Devrim GUNDUZ
Hi, On Wed, 8 Jun 2005, robert.lamie wrote: I'd like to know if it's possible to install Postgresql v8 on a RedHat 7.2 ? Yes, I think so. If ok, can I use the binaries distrib ? the source distrib ? red hat or fedora ? Is the RedHat-9 rpms install is compatible ? Sorry for the newbie ques

Re: [ADMIN] [Newbie] RedHat 7.2 & Postgresql 8

2005-06-08 Thread Bruno Wolff III
On Wed, Jun 08, 2005 at 09:38:36 +0200, "robert.lamie" <[EMAIL PROTECTED]> wrote: > Hi, > I'd like to know if it's possible to install Postgresql v8 on > a RedHat 7.2 ? If ok, can I use the binaries distrib ? the > source distrib ? red hat or fedora ? Is the RedHat-9 rpms > install is compatible

[ADMIN] Problems Connecting SSL enabled server

2005-06-08 Thread Nasir Iqbal Danish
I am using postgresql 8.0.3 and have compiled it with-openssl option. server configuration "ssl = true" is set. and pg_hba.conf has hostssl entry for my remote machine. when I tried to connect using psql it works file and connection type is SSL. But when I am trying to connect from pgadmin3 1.

[ADMIN] [Newbie] RedHat 7.2 & Postgresql 8

2005-06-08 Thread robert.lamie
Hi, I'd like to know if it's possible to install Postgresql v8 on a RedHat 7.2 ? If ok, can I use the binaries distrib ? the source distrib ? red hat or fedora ? Is the RedHat-9 rpms install is compatible ? Sorry for the newbie questions, and I know RH7.2 is pretty old but my customer has no oppor