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)
But are exactly same time
Why?
timestamp with timezone just show/hide time zone?
thanks
Yes, 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 will
through
,
when he restart the postgres server receive a KILL message and then
everything get worse
I live this situation time ago and obviously learn :)
-Mensaje original-
De: Anibal David Acosta [mailto:a...@devshock.com]
Enviado el: lunes, 17 de septiembre de 2012 09:27 p.m.
Para: 'Craig
Install Postgres in both server machine
Configure the MS Cluster Service, add the external storage and the Postgres
Service to your cluster group, and configure the postgres service to start
using the directory in the external storage.
Now you have a fail over database.
Add you application to
Is probably that the cause of this behavior are many many dead tuples in the
table.?
De: Anibal David Acosta [mailto:a...@devshock.com]
Enviado el: miércoles, 01 de agosto de 2012 04:27 p.m.
Para: pgsql-admin@postgresql.org
Asunto: Timeout error on pgstat
I have a lot (maybe 1
:01 p.m.
Para: Anibal David Acosta
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Timeout error on pgstat
On 08/02/2012 04:27 AM, Anibal David Acosta wrote:
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
A quick search suggests this can be due
)
A scan encountering many consecutive pages that contain no live tuples would
not respond to interrupts meanwhile
Maybe in the autovacuum happen something similar?
De: Anibal David Acosta [mailto:a...@devshock.com]
Enviado el: jueves, 02 de agosto de 2012 10:52 a.m.
Para: 'Craig Ringer'
CC
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
Also this
ERROR: canceling autovacuum task
In the pg_stat_activity show an autovacuum process over a very used table
that runs about 1 hour and then this vacuum is cancelled (according to log)
I have
But in windows, there are no support for x64.
I fact, if you have a x64 postgres version, pgAgent wont install
De: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] En nombre de Julien Rouhaud
Enviado el: viernes, 02 de diciembre de 2011 01:02 p.m.
Para: Rob
Hello, I have a postgres installed on a Windows server machine.
In my country we have daylight saving so my windows OS is configured to
automatically change timezone but the postgres only reload the new timezone
after restart.
Is possible to kept the Postgres in sync with the windows time (time
Hello, I have a postgres installed on a Windows server machine.
In my country we have daylight saving so my windows OS is configured to
automatically change timezone but the postgres only reload the new timezone
after restart.
Is possible to kept the Postgres in sync with the windows time (time
Hello.
I have two postgres 9.0 database both can be modified and both must have
same information.
In case of collision (same row changed in both) must win the most recent.
Thanks.
I think SAN is better for block access instead of file access (NAS)
-Mensaje original-
De: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] En nombre de Bryan Keller
Enviado el: miércoles, 09 de febrero de 2011 05:00 p.m.
Para: pgsql-admin@postgresql.org
Asunto:
Hi everyone.
I have been installed postgresql 9.0.2 on a windows 2008 x64 server.
The postgres is running, without any application accessing the server.
In the log appear : WARNING: pgstat wait timeout
This error appear constantly and some times when I do a query, very simple
query
Hi
I really like to do efficient SQL queries so, my question is if I am
expecting no more than one row from a select, using the LIMIT 1 could
improve the performance?
If I use my logic, the LIMIT 1 instruction tell to postgres that stop
searching when found 1 record, but maybe it is
is like this:
Select column1 from myTable where Column2 between X and Y
I am expecting just one record
De: Michael Holt [mailto:mich...@aers.ca]
Enviado el: jueves, 16 de diciembre de 2010 04:23 p.m.
Para: Anibal David Acosta; pgsql-admin@postgresql.org
Asunto: RE: [ADMIN] using limit
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-admin@postgresql.org;
pgsql-gene...@postgresql.org
Asunto: Re
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
Windows server enterprise has the Microsoft Cluster Services.
This enable fail-over scenario between two computers.
So, when one of them go offline, the other is activated, this involve many
steps, including IP changing, the slave become the master IP address .
But you can choose between
TrueCrypt is a free open source application, can encrypt any drive or create
a virtual encrypted drive.
-Mensaje original-
De: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] En nombre de Scott Marlowe
Enviado el: lunes, 05 de abril de 2010 05:35 p.m.
Para:
Try
function add_user(_user varchar(20), _password varchar(20))
INSERT INTO my_users(user, password) VALUES (_user, _password);
-Mensaje original-
De: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org]
En nombre de Julius Tuskenis
Enviado el: viernes, 19 de
MICRO-OLAP Database designer for postgres is a great tool.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de Carol Walter
Enviado el: lunes, 15 de septiembre de 2008 02:58 p.m.
Para: Thomas Jacob
CC: Barbara Stephenson; pgsql-admin@postgresql.org
Asunto:
Hello, I have a postgresql installed with encoding WIN1252.
But I need to create a DB with LATIN1 encoding, when I try I got the error:
Encoding Latin1 does not match server's locale Spanish_Spain.1252. The
servers's LC_CTYPE setting require encoding WIN1252
Is possible to change the
Maybe is a permission issue.
Go to All programs - Accessories and right click over command prompt
and run as administrator.
Then from the command prompt execute the installer (just put the complete
postgres installer path)
Maybe that help you.
De: [EMAIL PROTECTED]
of the corrupt data…
-Original
Message-
From: Anibal David
Acosta
[mailto:[EMAIL PROTECTED]]
Sent: Monday, 22
October 2007
15:33
To: Phillip Smith
Subject: Re: [ADMIN]
Please help
(backup)
I open with word pad
notepad, but table, functions and other object declarations looks like
"
I have a backup done with pg_dump utility.
For some reason the backup file has 8 phisical bad sectors (17 KB of data)
Now when I try to restore the backup all tables are created successfully
and data of almost all tables restores successfully too, but one table
(the most important) appear
Hello guys, recently I made a
backup of my entire database using pg_dump.
The backup was OK, but for some reason when I make the copy in my
storage device the back was copy wrong or something else.
Whe I try to copy the file from my storage a "Cycling reduncandy check
error appear", Finally
27 matches
Mail list logo
