Re: [GENERAL] Export binary data - PostgreSQL 9.2

2016-03-04 Thread Koray Eyidoğan
-b/--blobs option should be required when making selective dumps. I just wanted to note for the sake of completeness. Have a nice day. On Thu, Mar 3, 2016 at 3:50 AM, Abdul Sayeed wrote: > Hi, > > You can use pg_dump with -t and -Fc option to take dump of a table in > compressed format. > > $PG

Re: [GENERAL] pg_xlog Concern

2015-05-18 Thread Koray Eyidoğan
Hi, Any kind of slowness on your archive directory may cause the archiving process fall behind thus accumulating segment files in your cluster's pg_xlog directory. I assume that you are on PostgreSQL 9.4. Could you please check your archiver status by typing "select * from pg_catalog.pg_stat_arch