[ADMIN] Converting 7.2 to 6.5 database

2002-05-28 Thread Leandro Rodrigo Saad Cruz
Hi all, anyone here knows how can I convert a 7.2 database to 6.5 database format ??? -- Leandro Rodrigo Saad Cruz (WEBMAIL) IT - Inter Business Tecnologia e Servicos (IB) http://www.ibnetwork.com.br - This mail sent through IMP: http://horde

Re: [ADMIN] jdbc compile does not work

2002-05-28 Thread Egon Reetz
I had similar failures with JSDK 1.4, I used 1.3.1_03 instead and everything was ok. The build.xml file for the JDBC driver looks for a special class for deciding between J2EE and J2SE, but there were some changes between 1.3 and 1.4, so this way doesn't work. Egon "Ravi K.R." wrote: > JDBC co

[ADMIN] FATAL 1: Database "template0" is not currently accepting connections?

2002-05-28 Thread Don Saxton
Out of the blue I received this error running 7.2 on win 2k   FATAL 1:  Database "template0" is not currently accepting connections the immediate query was a select on a database but not template0.   I am curious to know if anyone has experienced this or might know the cause and / or cure.  

Re: [ADMIN] postgres 7.2.1 and pam

2002-05-28 Thread Peter Eisentraut
Georg Lutz writes: > My pg_hba.conf looks like this: > --- > local all md5 > local all pam postgresql > --- Both of these entries apply to local connections, so the first one gets used and PAM is ne

Re: [ADMIN] databases and RAID ...

2002-05-28 Thread Dmitry Morozovsky
On Fri, 24 May 2002, Kris Deugau wrote: [snip] KD> Note that if you're looking for a system you can hotswap, you will KD> probably need to go SCSI in any case; I'm not aware of any KD> hotswap-capable IDE RAID systems. Not exactly ;-) Promise TX2 and TX4 with special enclosures do the trick.

[ADMIN] two databases

2002-05-28 Thread Jodi Kanter
I'd like to set up two databases on one server but need information on securing them separately. The databases will be accessed by different groups, who cannot have access to the data on the other database. I assume that this can be done using Postgres 7.1.3. Am I correct? The database that I

Re: [ADMIN] two databases

2002-05-28 Thread Nick Fankhauser
Jodi- I've not actually tried this, but here is how I think you could set up a division such as you describe: Create two password files with pg_passwd. Edit pg_hba.conf to specify a different password file for each database: local database1 password passwords1 local database2 password password

Re: [ADMIN] two databases

2002-05-28 Thread Jean-Michel POURE
Le Mardi 28 Mai 2002 22:09, Jodi Kanter a écrit : > I'd like to set up two databases on one server but need information on > securing them separately. The databases will be accessed by different > groups, who cannot have access to the data on the other database. I assume > that this can be done us