[GENERAL] timezone, how postgres deal with it?

This query returns false select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) = ('2012-11-20 18:00:00-03:00'::timestamp with time zone) Why? Does postgres convert the datetime or just show/hide time zone?

Re: [GENERAL] [ADMIN] Windows Services and Postgresql 9.1.3

Yes, (I think) is a Bug, sometimes in some circumstances pg_ctl go down but postgres server still running. You can easily reproduce. Go to task manager, kill the process pg_ctl (simulate some kind of crash or something else). Now go to services management and try to start again. Start command

[GENERAL] change column data type of a big table

I have a very big table, in fact only this table uses approx. 60% space of disk. The table is an standalone table (no one inherit from this and this is not inherit from another). I need to change a int column to bigint. But aparentely this alter recreate the table, my problem is the space,

[GENERAL] how much volatile is a function

I have a table, this table are rarely changed (added or deleted). My function receive parameters and do a query to the table. Does postgres re run the query on each function call, or has some kind of flag indicating that table as not been changed and return cached result of a previous call if

Re: [GENERAL] Help, server doesn't start

lose J, but due te importance of the service we decide this instead of a long service down Thanks! De: Craig Ringer [mailto:ring...@ringerc.id.au] Enviado el: lunes, 25 de junio de 2012 12:54 a.m. Para: Anibal David Acosta CC: 'Raghavendra'; pgsql-general@postgresql.org Asunto: Re

Re: [GENERAL] Help, server doesn't start

times We plan to upgrade to version 9.1, do you know if file result of the pg_dump in 8.3 can be restored in 9.1? Thanks! De: Craig Ringer [mailto:ring...@ringerc.id.au] Enviado el: lunes, 25 de junio de 2012 12:54 a.m. Para: Anibal David Acosta CC: 'Raghavendra'; pgsql-general

[GENERAL] Help, server doesn't start

We have an old postgres installation (8.3) running on windows 2003 The server run perfect for many years but today it crash L We have a very old backup so I'll try desperate to repair. If I can't repair I want to skip the error and start server with only healthy data, no matter if I lose

Re: [GENERAL] Help, server doesn't start

@enterprisedb.com] Enviado el: lunes, 25 de junio de 2012 12:31 a.m. Para: Anibal David Acosta CC: pgsql-general@postgresql.org Asunto: Re: [GENERAL] Help, server doesn't start On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta a...@devshock.com wrote: We have an old postgres installation

[GENERAL] checkpoints are occurring too frequently

I have a lot of entries like this in the log file 2011-11-17 02:02:46 PYST LOG: checkpoints are occurring too frequently (13 seconds apart) 2011-11-17 02:02:46 PYST HINT: Consider increasing the configuration parameter checkpoint_segments. No, checkpoint parameters in postgres.conf are:

Re: [GENERAL] checkpoints are occurring too frequently

Thanks! -Mensaje original- De: Gabriele Bartolini [mailto:gabriele.bartol...@2ndquadrant.it] Enviado el: jueves, 17 de noviembre de 2011 10:14 a.m. Para: Anibal David Acosta CC: pgsql-general@postgresql.org Asunto: Re: [GENERAL] checkpoints are occurring too frequently Hi Anibal

[GENERAL] duplicate sequence, it is possible?

Hi everyone. I have a table with a PK, this table has a lot of insert per second (100 ~ 150 insert /sec) Sometimes, a get a duplicate key error, but ID is generated from a function (VOLATILE). This function has just one line (select nextval('XXX')) Is possible that this function return

[GENERAL] pgadmin Running VACUUM recommended

Hello, I have installed postgres 9.0 that is supposed has by default auto vacuum enabled But sometimes when I click over a table in the pgadmin, this application recommend me to vacuum The message is: The estimated rowcount on the table XXX deviates significantly from the actual rowcount.

Re: [GENERAL] How to recover a postgres installation from files

Thanks!!! I'll download right now :) -Mensaje original- De: Radosław Smogura [mailto:rsmog...@softperience.eu] Enviado el: jueves, 02 de diciembre de 2010 08:22 a.m. Para: Craig Ringer CC: Anibal David Acosta; pgsql-ad...@postgresql.org; pgsql-general@postgresql.org Asunto: Re

[GENERAL] How to recover a postgres installation from files

Hello. I have a not bootable Windows Server with Postgres 8.1, now I am trying to recover it but as I can't boot the windows, I can't start the postgres service and I can't do a Backup So, I only have the postgres directory on my hands. I decide to install the same database version in another

Re: [GENERAL] using float4, I get incorrect value when select

I am newbie in postgres. But I think that the value is stored correctly because when select and cast the column to float8 the postgres return the correct value and when I insert, no overflow or other error occur. Thanks Martijn Martijn van Oosterhout kleptog@svana.org escribió en el mensaje

[GENERAL] using float4, I get incorrect value when select

Hello, I have a table, with a float4 column, when I insert a new row and for example I use this value 5000542,5 in the column of type float4, the insert do OK, but when I select (select myColumn from myTable) I get the value 5000540 I don't know why. But if I cast to float8 (select