Re: [ADMIN] WAL archiving

2008-02-24 Thread Praveen Kumar (TUV)
Hello, If the machine where we have make setup for warm standby database goes down and we restart this machine again ,then what will be happen for Our warm standby database ,will it again start applying archive log from starting point ( archive log generated after taking online backup) or from

Re: [ADMIN] WAL archiving

2008-02-24 Thread Shilpa Sudhakar
Thanks Vishal. I got it now. Will test the archiving process. Vishal Arora wrote: > Date: Mon, 25 Feb 2008 15:30:46 +1030 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: pgsql-admin@postgresql.org > Subject:

Re: [ADMIN] Backup to Tape Incomplete

2008-02-24 Thread Scott Marlowe
On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith <[EMAIL PROTECTED]> wrote: > PostgreSQL 8.2.4 > RedHat ES4 > > I have a nightly cron job that is (supposed) to dump a specific database to > magnetic tape: > /usr/local/bin/pg_dump dbname > /dev/st0 > > This runs, and doesn't throw any erro

Re: [ADMIN] WAL archiving

2008-02-24 Thread Vishal Arora
> Date: Mon, 25 Feb 2008 15:30:46 +1030> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] WAL > archiving> > Thanks a lot Vishal for the info.> > I have one more query > postgres automatically cleans the WAL files > present in the pg_xlog

Re: [ADMIN] WAL archiving

2008-02-24 Thread Shilpa Sudhakar
Thanks for the link Vishal Regards, Shilpa Vishal Arora wrote: You can have a warm standby system in place. Pls check this link - http://archives.postgresql.org/sydpug/2006-10/msg1.php > Date: Mon, 25 Feb

Re: [ADMIN] WAL archiving

2008-02-24 Thread Shilpa Sudhakar
Thanks a lot Vishal for the info. I have one more query postgres automatically cleans the WAL files present in the pg_xlog directoryright? So instead of me creating a separate folder as i've done in my current settings (wal_log), should i need to change the archive_command to point to pg_x

Re: [ADMIN] WAL archiving

2008-02-24 Thread Shilpa Sudhakar
Thanks loads Dawid, I'll test the process on the TEST box and note down the time it takes. Dawid Kuroczko wrote: On Fri, Feb 22, 2008 at 12:23 AM, Shilpa Sudhakar <[EMAIL PROTECTED]> wrote: Since the wal logs keep increasing, do we take the base backup every now and then so that we can

[ADMIN] Backup to Tape Incomplete

2008-02-24 Thread Phillip Smith
PostgreSQL 8.2.4 RedHat ES4 I have a nightly cron job that is (supposed) to dump a specific database to magnetic tape: /usr/local/bin/pg_dump dbname > /dev/st0 This runs, and doesn't throw any errors, but when I try to restore it fails because the tape is incomplete: [EMAIL PROTEC

Re: [ADMIN] WAL archiving

2008-02-24 Thread Vishal Arora
You can have a warm standby system in place. Pls check this link - http://archives.postgresql.org/sydpug/2006-10/msg1.php > Date: Mon, 25 Feb 2008 09:54:34 +1030> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] WAL > archiving> > S

Re: [ADMIN] WAL archiving

2008-02-24 Thread Dawid Kuroczko
On Fri, Feb 22, 2008 at 12:23 AM, Shilpa Sudhakar <[EMAIL PROTECTED]> wrote: > Since the wal logs keep increasing, do we take the base backup every now > and then so that we can delete the old log files? > How often do we take a base filesystem backup keeping in mind that our > systems are

Re: [ADMIN] PL/pgSQL memory consumption?

2008-02-24 Thread Dawid Kuroczko
On Fri, Feb 22, 2008 at 3:54 PM, Tom Lane <[EMAIL PROTECTED]> wrot> "Dawid Kuroczko" <[EMAIL PROTECTED]> writes: > > I have recently found a nice utility called memstat (which shows how > > much of private > > (not shared)) memory each process uses. What kind of surprised me was > > the amount

Re: [ADMIN] WAL archiving

2008-02-24 Thread Shilpa Sudhakar
Shilpa Sudhakar wrote: Hi Vishal, Below is the setup in the postgresql.conf file fsync = true# turns forced synchronization on or off wal_sync_method = fsync # the default varies across platforms: #wal_buffers = 8# min 4, 8KB each #commit_delay = 0

Re: [ADMIN] postsql on vista

2008-02-24 Thread Anibal David Acosta
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

Re: [ADMIN] out of shared memory

2008-02-24 Thread ntr
how much is your sharemem ? On Sun, Feb 24, 2008 at 12:40 AM, Guillermo Arias <[EMAIL PROTECTED]> wrote: > Hi this message appears while doing a query. ¿What can i do? > > ---(end of broadcast)--- > TIP 7: You can help support the PostgreSQL project

[ADMIN] postsql on vista

2008-02-24 Thread rose .....
hello, i am trying to install the postgre sql on windows vista , i followed all the wizard steps but each time, before compeleting installation , it gives the foolwing error : "the user 'postgre' could not be found. access denied! i don't know if this because i am using vista or what? thank

[ADMIN] out of shared memory

2008-02-24 Thread Guillermo Arias
Hi this message appears while doing a query. ¿What can i do? ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate