[GENERAL] Ident authentication failed for user

Hi: I cannot connect to my Postgres database from my PHP scripts. I get the error: PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user postgres in ... I have tried many combinations for host TYPE in pg_hba.conf (restarting

Re: [GENERAL] Ident authentication failed for user

Hi John. Thanks a lot for your reply: El día 1 de marzo de 2012 17:25, John R Pierce pie...@hogranch.com escribió: On 03/01/12 9:02 AM, Ruben Blanco wrote: specify host=localhost, otherwise its using the first 'local' line, which specifies 'ident' authentication, as the error implies. Where

[GENERAL] Partial index does not make query faster

Hi, folks: I'm trying to reduce execution time on a query using a partial index, but Postgres doesn't make a significant improvement, even when the partial index is 30 times smaller than the index used currently. Query plan returns a slightly higher cost (cost=0.00..327952.12) for the partial

[GENERAL] Worse performance on partitioned table than in non partitioned table

Hi: After partitioning a big table, I am getting slower performance on queries run on the non-partitioned table (llamadas) than the partitioned table (llamadas_maestra). Not partitioned table: heos_prod=# explain analyze select * from llamadas where cod_empresa=1 and

[GENERAL] Create unique index or constraint on part of a column

Hi: Is there anyway to create a unique index or constraint on part of a column? Something like this, but something that works ;-) ALTER TABLE invoices ADD CONSTRAINT cons UNIQUE (EXTRACT(YEAR FROM invoice_date), innvoice_number); Thanks for any help. Ruben,

Re: [GENERAL] Heavy queries not run by user application

Thanks a lot, guys. There were two users running Navicat, and these killer queries are indeed run by this program. Rubén. 2011/2/13 John R Pierce pie...@hogranch.com On 02/12/11 5:11 PM, Ruben Blanco wrote: Hi: I'm running a Postgres database with a total disk occupation of 100Gb, largest

[GENERAL] Heavy queries not run by user application

Hi: I'm running a Postgres database with a total disk occupation of 100Gb, largest and most used table up to 40Gb (about 30.000.000 tuples). Overall performance degrades sometimes due to some queries that are not run by the final user app. I guess they are run by Postgres itself. They use to

[GENERAL] How to free disk space

Hi: My database is growing fast taking too much disk space. How can I free disk space without performing a VACCUM FULL? It locks the database for several hours, and that is not a solution. I guess a backup-restore would do the work but, isn't there a better way to do this without shutting down

Re: Fw: Re: [GENERAL] Recovering data from corrupted table. Urgent

Thanks Martijn: It worked. I was having issues with 7.4.2, run memory ans disk checks and hardware seems ok, that's why I decided to upgrade to 7.4.5, but unfortunately I'm still experiencing data corruption. Ruben. ruben20 wrote: -- Forwarded Message --- From: Martijn van