Postgres 8.0.2 for
Windows is install on a Microsoft Windows Server 2003 system. The installation
was made with all the default values.
We made a backup of
one of our database with the following instruction :
pg_dump –i –h serverName –p
5432 –U userName –W password –F c backupFileName
da
Hello all
I'm trying to restore in a cluster using pg_restore and i'm receiving an
error from my recoverylog saying that there is no last checkpoint for my
backend. How can I alter pg_restore to make it work or do i have any
other options. Tahnk you in advance.
begin:vcard
fn:Joshua O'Brien
How can I install pg_xlog (WAL) in another partition, i mean separate
the data directory from WAL, i have a single scsi disk with four
partitions
/, /boot, /data(data for postgresql), /WAL(pg_xlog), i ve heard that by
doing this occurs a boost in postgreSQL performance, thanks in advance
anyone tha
On Mon, 2005-12-12 at 10:08, jose fuenmayor wrote:
> How can I install pg_xlog (WAL) in another partition, i mean separate
> the data directory from WAL, i have a single scsi disk with four
> partitions
> /, /boot, /data(data for postgresql), /WAL(pg_xlog), i ve heard that
> by doing this occurs a
jose fuenmayor <[EMAIL PROTECTED]> writes:
> How can I install pg_xlog (WAL) in another partition, i mean separate the
> data directory from WAL, i have a single scsi disk with four partitions
> /, /boot, /data(data for postgresql), /WAL(pg_xlog), i ve heard that by
> doing this occurs a boost in p
On Mon, Dec 12, 2005 at 10:23:09AM -0500, Josh O'Brien wrote:
> I'm trying to restore in a cluster using pg_restore and i'm receiving an
> error from my recoverylog saying that there is no last checkpoint for my
> backend. How can I alter pg_restore to make it work or do i have any
> other opti
[Please copy the mailing list on replies.]
On Mon, Dec 12, 2005 at 11:57:06AM -0500, Josh O'Brien wrote:
> this is the command --create --format=c -d template1
> /home/postgres/dumps/test_dump test_db.
That's not a complete command; I assume those are the options and
arguments to pg_restore. As
All the documentation I've seen for PITR points to having to do a file system copy of sorts.
Is it possible to have a weekly pg_dump and restore the database up to
the last archived WAL file if the db server fails? If so, how? Is it
just a matter of restoring the database then copying the archive
Any plans of incorporating it into a future release? How do people
currently deal with this problem? I wonder if this is fixed in the
pg_autovacuum distributed with v8.1
On Sun, 11 Dec 2005, Matthew T. O'Connor wrote:
> Unfortunately, you are correct, there is no way to tell
> contrib/autovacu
Most people running Linux would add it to their logrotate.conf or other log
management methods.
On Mon, 12 Dec 2005, Ameet Kini wrote:
Any plans of incorporating it into a future release? How do people
currently deal with this problem? I wonder if this is fixed in the
pg_autovacuum distribut
Ameet Kini wrote:
>
> Any plans of incorporating it into a future release? How do people
> currently deal with this problem? I wonder if this is fixed in the
> pg_autovacuum distributed with v8.1
8.1 does not have this problem, because autovacuum got integrated into
the server proper and no longe
11 matches
Mail list logo
