[ADMIN] Re: [ADMIN] large database: problems with pg_dump and pg_restore

2010-10-27 Thread Martin Povolny
27.10.2010 t...@sss.pgh.pa.us napsal(a): > =?utf-8?Q?Martin_Povolny?= writes: >> I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping: I >> was unable to >> make a dump in the default 'tar' format. I got this message: >> pg_dump: [tar archiver] archive member too large for tar forma

Re: [ADMIN] large database: problems with pg_dump and pg_restore

2010-10-27 Thread Jehan-Guillaume (ioguix) de Rorthais
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Le 27/10/2010 04:41, mark a écrit : > A long time ago, (8.1.11 IIRC) > > We got much better speed not using the compression flag with pg_dump instead > piping to gzip (or better yet something like pbzip2 or pigz, but I haven't > used them). > > I

[ADMIN] Using LDAP with postgresql 8.2

2010-10-27 Thread Kieren Scott
Hi, I'm looking to implement LDAP authentication againt Active Directory for my Postgresql databases. What's people experiences of using LDAP for authenticating logins with AD? Is it easy to setup and is there anything to watch out for e.g. does Postgresql do anything intrusive on Active Dire

[ADMIN] PG 9.0 streaming replication cfg question

2010-10-27 Thread Isabella Ghiurea
Hi All, I'm trying to configure PG 9.0.1 with streaming replication and WAL shipping in same time, what will be pros and cons for using dedicated user for replication aka: replication_user than the regular user :postgres. Any issues with WAL files ownership when they must be copied and lo