Re: [ADMIN] PostgreSQL-9.0.1

2011-08-18 Thread Venkat Balaji
Hi Raghav, I have zlib, zlib-devel installed in my system. There seems to be some problem with ".o" files. I tried to install after "make clean" and "make distclean" as well. I believe, there must be some options to be used with make. Thanks Venkat N On Thu, Aug 18, 2011 at 5:47 PM, Raghaven

Re: [ADMIN] PostgreSQL-9.0.1

2011-08-18 Thread Venkat Balaji
Hi Devrim, Great to get a reply from your end ! We would definitely use rpm based installers. We have been using community version tars (source installers) for all our production setups. Could you let us know what things are to be looked at if we switch over to rpm based installers ? (things li

Re: [ADMIN] Question on Postgres Index internals

2011-08-18 Thread Craig Ringer
On 19/08/2011 5:46 AM, A J wrote: How does Postgres detect corruption of index data files ? If their structure doesn't make sense, they're corrupt. It doesn't actively seek or detect corruption, because it shouldn't happen, and cannot be reliably discovered if it has. What is the exact mechani

[ADMIN] Londiste won't start with dual IP addresses

2011-08-18 Thread Craig James
We had to temporarily assign two IP addresses to our servers. After doing so and rebooting, Londiste will start, but it just sits there doing nothing. The logfile has zero bytes, and it doesn't seem to connect to either the master or the slave database. We reconfigured Postgres to listen on

[ADMIN] Question on Postgres Index internals

2011-08-18 Thread A J
How does Postgres detect corruption of index data files ? What is the exact mechanism by which it knows that the index is corrupt ? Can it happen that part of the index is corrupt but Postgres does not realize because those specific rows are not accessed (but other rows from that table are acces

[ADMIN] Validate standby against master

2011-08-18 Thread A J
What are the various ways in which I can validate that a standby (new or existing) is caught-up with the master ? For streaming replication setup in v9.x

Re: [ADMIN] [GENERAL] Suspicious Bill

2011-08-18 Thread Chaitany Kulkarni
Soory for my previous mail regarding GM crops in india. I didn't sent it personally t every one, but when just provided login details to a site, it fetched all contacts and sent a email to them. Sorry about this. shreeseva...@gmail.com On Thu, Aug 18, 2011 at 10:53 PM, Ben Chobot wrote: > While

[ADMIN] Suspicious Bill

2011-08-18 Thread shreeseva.it
Hi ,I just signed a petition asking Prime Minister Manmohan Singh to stop the Biotechnology Regulatory Authority of India (BRAI) Bill from being passed. This bill will create a body which will single-handedly clear all genetically modified (GM) crops. Public opposition made the Karnataka gov

Re: [ADMIN] Unable to login with phppgadmin on a remote host

2011-08-18 Thread Jehan-Guillaume (ioguix) de Rorthais
On 18/08/2011 17:55, Tom Browder wrote: > On Thu, Aug 18, 2011 at 08:48, Jehan-Guillaume (ioguix) de Rorthais > wrote: >> On 18/08/2011 15:37, Tom Browder wrote: >>> On Thu, Aug 18, 2011 at 07:37, Jehan-Guillaume (ioguix) de Rorthais >>> wrote: On 18/08/2011 13:54, Tom Browder wrote: > O

Re: [ADMIN] Unable to login with phppgadmin on a remote host

2011-08-18 Thread Jehan-Guillaume (ioguix) de Rorthais
On 18/08/2011 15:37, Tom Browder wrote: > On Thu, Aug 18, 2011 at 07:37, Jehan-Guillaume (ioguix) de Rorthais > wrote: >> On 18/08/2011 13:54, Tom Browder wrote: >>> On Thu, Aug 18, 2011 at 05:40, (ioguix) de Rorthais wrote: On 18/08/2011 01:20, Tom Browder wrote: > ... > However, I can

Re: [ADMIN] Unable to login with phppgadmin on a remote host

2011-08-18 Thread Tom Browder
On Thu, Aug 18, 2011 at 07:37, Jehan-Guillaume (ioguix) de Rorthais wrote: > On 18/08/2011 13:54, Tom Browder wrote: >> On Thu, Aug 18, 2011 at 05:40,  (ioguix) de Rorthais wrote: >>> On 18/08/2011 01:20, Tom Browder wrote: ... However, I cannot successfully login with phppgadmin on the remo

Re: [ADMIN] PostgreSQL-9.0.1

2011-08-18 Thread Devrim GÜNDÜZ
On Thu, 2011-08-18 at 17:06 +0530, Venkat Balaji wrote: > > I am getting the following error when trying to install PG-9.0.1 - Why don't you use RPMs for that? http://yum.pgrpms.org (and please use 9.0.4) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterp

Re: [ADMIN] Unable to login with phppgadmin on a remote host

2011-08-18 Thread Jehan-Guillaume (ioguix) de Rorthais
On 18/08/2011 13:54, Tom Browder wrote: > On Thu, Aug 18, 2011 at 05:40, (ioguix) de Rorthais wrote: >> Hello, >> On 18/08/2011 01:20, Tom Browder wrote: > ... >>> I have these lines in my pg_hba.conf file: >>> >>> host all myuser /32 md5 >>> host all pos

Re: [ADMIN] PostgreSQL-9.0.1

2011-08-18 Thread Raghavendra
I think you should also need 'zlib-devel', check with the rpm's list of zlib in your OS. --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Thu, Aug 18, 2011 at 5:06 PM, Venkat Balaji wrote: > Hello Community, > > I am getting the following error when tryin

Re: [ADMIN] Unable to login with phppgadmin on a remote host

2011-08-18 Thread Tom Browder
On Thu, Aug 18, 2011 at 05:40, (ioguix) de Rorthais wrote: > Hello, > On 18/08/2011 01:20, Tom Browder wrote: ... >> I have these lines in my pg_hba.conf file: >> >> host  all             myuser         /32         md5 >> host  all             postgres       /32         md5 >> >> However, I canno

[ADMIN] PostgreSQL-9.0.1

2011-08-18 Thread Venkat Balaji
Hello Community, I am getting the following error when trying to install PG-9.0.1 - pg_backup_archiver.o: In function `SetOutput': pg_backup_archiver.c:(.text+0x2b6f): undefined reference to `gzopen64' pg_backup_files.o: In function `_StartBlob': pg_backup_files.c:(.text+0x50d): undefined referen

Re: [ADMIN] Unable to login with phppgadmin on a remote host

2011-08-18 Thread Tom Browder
On Wed, Aug 17, 2011 at 19:14, Craig Ringer wrote: > On 18/08/2011 7:20 AM, Tom Browder wrote: >> >> I have installed postgresql 9.0.4 from source on aUbuntu 10.04 LTS >> 64-bit remote host. >> >> I have installed phppgadmin, Apache2, and other required programs and >> libraries via the Ubuntu pac

Re: [ADMIN] Unable to login with phppgadmin on a remote host

2011-08-18 Thread Jehan-Guillaume (ioguix) de Rorthais
Hello, On 18/08/2011 01:20, Tom Browder wrote: > [...] > > I have these lines in my pg_hba.conf file: > > host all myuser /32 md5 > host all postgres /32 md5 > > However, I cannot successfully login with phppgadmin on the remote host. > >