Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

2015-10-28 21:09 GMT+01:00 anj patnaik : > I was trying to achieve smallest file possible so tried the xz. Right now > the db size returned from SELECT > pg_size_pretty(pg_database_size('postgres') is 1.4 GB and the size of the > dump with xz is 2.2 GB. > > Is there a limit to

Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

>Probably not a good idea to put your data in the postgres database. This is one of the system databases created by >initdb and is meant to be used as a default database to connect to, not really as one to store data in. Just did a test >with pg_dumpall and it is not dumped when you backup the

Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

On 10/29/2015 10:54 AM, Melvin Davidson wrote: >Probably not a good idea to put your data in the postgres database. This is one of the system databases created by >initdb and is meant to be used as a default database to connect to, not really as one to store data in. Just did a test >with

Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

I was trying to achieve smallest file possible so tried the xz. Right now the db size returned from SELECT pg_size_pretty(pg_database_size('postgres') is 1.4 GB and the size of the dump with xz is 2.2 GB. Is there a limit to the size of the database that pg_dump will run on? Will it work when db

Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

On 10/28/2015 01:09 PM, anj patnaik wrote: I was trying to achieve smallest file possible so tried the xz. Right now the db size returned from SELECT pg_size_pretty(pg_database_size('postgres') is 1.4 GB and the size of the dump with xz is 2.2 GB. Probably not a good idea to put your data in

Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

On 2015-10-28 14:09, anj patnaik wrote: > > Also, I want to know if anyone has found any handy cron scripts for automated > backups to run on a daily/weekly basis? i found some on google, but interested > to know if there are better ones. It does a lot more but: https://github.com/wal-e/wal-e

Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

On 10/27/2015 04:10 PM, anj patnaik wrote: I am running pg_dump on a database while on another machine running a loop to do insertions. Does pg_dump wait for idle activity before it completes or how does it determine when it has all the records needed for archiving?

[GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

I am running pg_dump on a database while on another machine running a loop to do insertions. Does pg_dump wait for idle activity before it completes or how does it determine when it has all the records needed for archiving? I am using the compressed mode and also using xz. Thanks, ap