Re: [ADMIN] WAL files backup

Im back working on PITR with WAL files. I was busy creating a PITR based file backup procedure in bash that works just like my boss want it to. that was complementary to the backup I want to discuss with you; shouldn't it work? I have repeated this procedure a few times with the same results, so

Re: [ADMIN] WAL files backup

On 2/18/07, pedro noticioso <[EMAIL PROTECTED]> wrote: -rw--- 1 postgres staff 234 2007-02-16 10:12 00010003 -rw--- 1 postgres staff 234 2007-02-16 10:12 00010004 -rw--- 1 postgres staff 234 2007-02-16 10:12 00010005.0024FD70.back

Re: [ADMIN] WAL files backup

Thanks to all who have repplied so far Ok so I go back and retry the complete procedure to try to pin point what might be the problem. 1) POSTGRES NEW INSTALL 2) CREATE TESTING DATABASE # createdb Test 3) INSERT A LOT OF DATA INTO 'Test' # insert into users values (1 ,'name','800122','2 some

Re: [ADMIN] WAL files backup

pedro noticioso wrote: > Muchas gracia a todos los queme han respondido hasta > ahora > Thanks to all who have repplied so far Pedro, I don't think you're doing anyone (nor yourself) any favors by writing both in spanish and english in this list. This list is english only. If you want to write i

Re: [ADMIN] WAL files backup

Muchas gracia a todos los queme han respondido hasta ahora Thanks to all who have repplied so far Ok entonces regreso y reinicio al procedimiento completo para tratar de atinarle a lo que puede ser el problema. Ok so I go back and retry the complete procedure to try to pin point what might be the

Re: [ADMIN] WAL files backup

On 2/16/07, Andy Shellam (Mailing Lists) < [EMAIL PROTECTED]> wrote: Why bother trying to delete WAL files older than the .backup file? When PostgreSQL is in recovery mode it knows which WAL files are necessary to perform the recovery. Also, the documentation recommends excluding the pg_xlog

Re: [ADMIN] WAL files backup

Chad Wagner wrote: On 2/15/07, *Eduardo J. Ortega* <[EMAIL PROTECTED] > wrote: After erasing the "less than names" WAL files, we add to tar the remaining WAL records (0003B, 0003C and so on on the example). The more WAL files you have after 0003B,

Re: [ADMIN] WAL files backup

On 2/15/07, Eduardo J. Ortega <[EMAIL PROTECTED]> wrote: After erasing the "less than names" WAL files, we add to tar the remaining WAL records (0003B, 0003C and so on on the example). The more WAL files you have after 0003B, the more up to date DB you get after restore (since it has more WAL

Re: [ADMIN] WAL files backup

OK, a couple of issues: 1) creation date and time on pg_xlog file is irrelevant, since AFAIK, they are recycled. 2) Why do you start_backup, archive WAL files somewhere else and then stop backup? If i understand correctly, you are explaining the process of data creation, backup and restoratio

Re: [ADMIN] WAL files backup

pedro noticioso <[EMAIL PROTECTED]> writes: > I created a log of my complete procedure so far, and > the error message at the end, pleasse help me find > exactly what is wrong, thanks It looks to me like you've gotten confused about which installation is the original and which is the attempted rec

Re: [ADMIN] WAL files backup

pedro noticioso wrote: > regresamos wal files a pg_xlog - COPY BACKED UP WAL > FILES BACK TO pg_xlog DIRECTORY This step is wrong. You don't have to manually put the pg_xlog files in the pg_xlog directory -- you have to let the recovery_command copy them back from the archive area. Note that re

Re: [ADMIN] WAL files backup

I created a log of my complete procedure so far, and the error message at the end, pleasse help me find exactly what is wrong, thanks 1) Postgres recien instalado - POSTGRES NEW INSTALL 2) Creando db de Pruebas - - CREATE TESTING DATABASE # createdb Test 3) iniciamos procedimiento de respaldo

Re: [ADMIN] WAL files backup

for the base backup I tried with the procedure outlined in http://www.postgresql.org/docs/8.1/static/backup-online.html#BACKUP-BASE-BACKUP and using tar zcvf /usr/local/pgsql/data/ and to restore deleted WAL files at pg_xlog because they are older than the WAL files in /backup/wals dir mentione

Re: [ADMIN] WAL files backup

hi: You enable WAL archiving by setting an appropiate archive_command in your postgresql.conf (probably something copying the WAL files somewhere you store them). You MUST restart postgres after changing this file. About the WAL file size: sorry, i don't know exactly how to do that. I do know

Re: [ADMIN] WAL files backup

Everyone please excuse the mistake in my previous question, there is a lot in my mind. We are already creating a complete backup every day, and would like to have WAL files to restore up to the last minute of course. Acording to http://www.postgresql.org/docs/8.1/static/runtime-config-wal.html#

Re: [ADMIN] WAL files backup

What do you mean by indentical here? does it mean that they are same in size, if that is true then yes they should be same in size unless you specify archive_timeout (8.2 config parameter) setting to do a log switch after certain amount of time. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com)

Re: [ADMIN] WAL files backup

For what i understand, the WAL files only record changes to the database, so each WAL segment is absolutely different from the previous one. As a matter of fact, each WAL file is the incremental backup you want to make (provided you have already taken a base or level 0 backup). On Monday 12 Feb

[ADMIN] WAL files backup

hi there I lightly read this http://www.postgresql.org/docs/8.1/static/backup-online.html and am interested in creating an incremental backup of WAL files, but my database is small so each of this WAL files must be almost identical to the previous one. Is there a way to incrementally backup so t