[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, th

[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 i

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

maybe was repeated many 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: 'Rag

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

ill know what I 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@

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

aghavendra@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 wrote: We have an old postgres installation (

[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 som

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] 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

[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 sam

[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. Y

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 Asunt

[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 c

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" escribió en el mensaje news:[EMAIL PROT

[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 cast(myC