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 I
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 em
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
&
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]
[ma
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
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: Re:
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 mar
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: T
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 h
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
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
Asunt
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 unnecessa
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
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 l
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:
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.
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 a
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 a
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 Rich
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
to de 2012 10: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
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 Ringe
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
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 cl
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
thro
the only thing he can do... Restart the server,
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 se
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
27 matches
Mail list logo