Hello all,
I want to have a fresh copy of my postgres database on another server in
order to provide a simple mechanism of failover.
My current solution is to backup the database every hour and re-create
from scratch on the other side.
Currently the database is small and its not an issue but
Hello,
On Fri, 28 Dec 2007 10:15:05 +0100 Pascal Heraud wrote:
What are the other solution to provide this service in a incremental
manner ? Is there any dupplication tool or mechanism provided to allow
such a repplication ?
One solution is Slony to replicate tables to another database.
Pascal Heraud a écrit :
Hello all,
I want to have a fresh copy of my postgres database on another server
in order to provide a simple mechanism of failover.
My current solution is to backup the database every hour and re-create
from scratch on the other side.
Currently the database is small
Pascal Heraud a écrit :
Is there any specific issues with gentoo ?
no, there is nothing specific to Gentoo, but the power of Gentoo is the
tweaking, not the stable production server you can expect to admin quietly .
search [Slony1-general] 2 problems thread on slony-I mailing list.
and
Admin team,
We are upgrading from Postgres 7.4.5 to 8.2.5 in mid January. We are also
adding new disks
As we go. I am investigating using the new tablespace facility to move our
biggest and most accessed
Table to the new disk. Here are the statistics. We are running RAID 10
Current
On Tue, Dec 18, 2007 at 12:55 PM, in message [EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] wrote:
David F. Skoll [EMAIL PROTECTED] writes:
My question is this: If the master database is fairly busy, gets
VACUUMed once a day, etc. can we expect the warm standby server
to work correctly after
Am Freitag, 28. Dezember 2007 schrieb Mark Steben:
As we go. I am investigating using the new tablespace facility to move our
biggest and most accessed
I didn't see anything in your description about having the WAL on a separate
disk. You should include that in your plans.
--
Peter
Kevin Grittner wrote:
On Tue, Dec 18, 2007 at 12:55 PM, in message [EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] wrote:
David F. Skoll [EMAIL PROTECTED] writes:
My question is this: If the master database is fairly busy, gets
VACUUMed once a day, etc. can we expect the warm standby
On Dec 28, 2007 5:58 PM, Cédric Villemain [EMAIL PROTECTED]
wrote:
Pascal Heraud a écrit :
Is there any specific issues with gentoo ?
no, there is nothing specific to Gentoo, but the power of Gentoo is the
tweaking, not the stable production server you can expect to admin quietly
.
search
PostgreSQL 8.2.4 on RedHat ES4 64-bit
Hi all,
Doing some works on a database this morning (changing it to take data from
our new ERP system) so naturally I made a backup of the database first:
pg_dump important_database ~/backup/important-071229.sql
chmod 440
Phillip Smith [EMAIL PROTECTED] writes:
But I get a whole bunch of errors, for example:
snip
ERROR: syntax error at or near all
LINE 1: all orders over $400.00 - freight free Order 10 of any produ...
^
Please show us the *first* few errors, not some randomly chosen ones.
The above
Sorry Tom - I should know better :)
I've attached the first 512 lines of the output from psql. The whole output
is 3mb.
Cheers,
~p
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, 29 December 2007 13:26
To: Phillip Smith
Cc: pgsql-admin@postgresql.org
Phillip Smith wrote:
Sorry Tom - I should know better :)
I've attached the first 512 lines of the output from psql. The whole output
is 3mb.
You have several problems in this dump. One it appears that some of the
releations already exist. Did you by chance accidently create stuff
within
Phillip Smith [EMAIL PROTECTED] writes:
I've attached the first 512 lines of the output from psql. The whole output
is 3mb.
Hmm, these are a bit troubling:
ERROR: relation grps already exists
...
ERROR: relation stock already exists
because you claimed you were restoring into an empty
14 matches
Mail list logo