[ADMIN] pg_dump, pg_restore and tablespaces

2005-12-05 Thread Colton Smith
Hi: Let's say I have a database comprised of tables scattered over several tablespaces. Suppose I need to move the database to another server and I can't use the same pathnames for the tablespaces. Am I out of luck when it comes to using pg_dump and pg_restore? Thanks! -

[ADMIN] ssl and/or md5 encryption

2005-12-05 Thread Colton A Smith
Hi: I specify md5 encryption in my pg_hba.conf file. Would using SSL on top of this be overkill? Thanks ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] Database testing.

2005-12-05 Thread Niv Cohen
Title: Database testing. Hi, My questions are regarding the way you are doing tests to your database. 1.  Can you explain in general the method you test the database engine. 2.  Are you doing testing for data integrity? 3.  Are you using a special tool for testing? If yes, is

Re: [ADMIN] ssl and/or md5 encryption

2005-12-05 Thread Michael Fuhr
On Wed, Nov 30, 2005 at 08:24:34AM -0500, Colton A Smith wrote: > I specify md5 encryption in my pg_hba.conf file. Would using SSL on > top of this be overkill? Specifying md5 in pg_hba.conf affects only password authentication; everything else will be sent in cleartext. What's your threat mo