Re: [ADMIN] Re: Restore template1

2000-12-20 Thread Oliver Elphick
Luis Sousa wrote: >What really does "initdb" ? > >It creates a new database system but is for use of the user that created her >!!! initdb creates the database structure including a database (template1) which is the model for all other databases created in the future. The whole structur

RE: [ADMIN]

2000-12-20 Thread Michael B. Babakov
On 20-Dec-00 khalid Gaffar wrote: > During the installation of PostgreSQL , I execute the initdb command using > the postgres user account. I get the following error message: > > pg_encoding: error in loading shared libraries: pg_encoding: undefined > symbol: pg_char_to_encoding How you mak

[ADMIN] Postgres Installation on Windows Machine

2000-12-20 Thread C.P.Maneesh
Hello I would like to know the procedure to install PostGres on Windows NT machine. Also, if you could please also send me the Installation Procedure File for Windows NT machine it would be very helpful to me. At present, I have the postgresinstall.tar (which contains the postgresql-7.0.tar a

[ADMIN] socket connections

2000-12-20 Thread Stuart Green
How do you force a postgres connection via a TCPIP socket and not a Unix Socket when connecting through the perl DBI? I found something in the postgres docs in the SSL area with a switch "-h localhost" (this is not in the man pages) but that didn't seem to do anything. Thanks

[ADMIN] Pb with more than 20 users

2000-12-20 Thread jmlm
Hi, I'm running postgres 7.02-3 with -N 64 -B 192 parameters. it runs on a RedHat 6.2 with : APACHE 1.3.12 EXIM 3.14 OPENSSH... (a complete application server). When I ran postgres without those parameters, everything was OK but I need more Backends so I put those parameters and everything go w

[ADMIN] Re: Problem with installing the data directory

2000-12-20 Thread Kristiansen Owe
See the old case from Mon, 10 Jul 2000 11:32:44 +0200. We did not find anything about this on the net, so we put effort in solving the problem ourself. We have found a possible reason. Our debian linux distribution had a 6.3... installation of PostgreSQL. The old binaries was executed instead of t

[ADMIN]

2000-12-20 Thread khalid Gaffar
During the installation of PostgreSQL , I execute the initdb command using the postgres user account. I get the following error message: pg_encoding: error in loading shared libraries: pg_encoding: undefined symbol: pg_char_to_encoding We are initializing the database system with username pos

Re: [ADMIN] Help me for "DBI->connect failed: Sorry, too many clientsalready."

2000-12-20 Thread Jie Liang
Hi,there, I hope it helps; 1. postgres by default allows 16 sessiones(if I don't remember wrong) at same time. You can change the setting according to the doccument. open too many sessiones at same time will more or less affect the performance. 2. I believe that using Pg module will be

[ADMIN] Re: Restore template1

2000-12-20 Thread Luis Sousa
What really does "initdb" ? It creates a new database system but is for use of the user that created her !!! Luis Sousa Ragnar Kjørstad wrote: > On Mon, Dec 18, 2000 at 03:49:18PM +, Luis Sousa wrote: > > There's a way to backup template1 to restore it when happens a disaster > > without