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 datab
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 pleas
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 dat
>>> 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 wor
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 Eisent
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 t
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
> .
>
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 ~/backup/important-07
"Phillip Smith" <[EMAIL PROTECTED]> writes:
> But I get a whole bunch of errors, for example:
>
> 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 a
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 tem
"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
14 matches
Mail list logo
