Running PostgreSQL 6.4 under Linux
2 queries with which I will be very grateful if answered.
1. The temp area
I'm previously an Oracle DBA (apologies if I just blasphemed). Oracle
allowed a designated area for temporary objects to
be created. This was used by, for example, executing SQL statements. My
question is how or where does Postgres
execute SQL statements. Is it on the <home>/base/<db> directory or the /tmp
directory and, therefore, can I change this.
2. Controling open connections
I don't seem to be able to find any way to change the number of open
connections that Postgres allows.
Linux allows a process 256; but if there are 33 Postgres connections, the
34th connection to Postgres gives the following
error :
----------------------------------------------------------------------------
-------------------------------
NOTICE: SIAssignBackendId: discarding tag 2147483647
FATAL 1: Backend cache invalidation initialization failed at ./openDB.pl
line 17
34 - Cannot connect to db : FATAL 1: Backend cache invalidation
initialization failed
----------------------------------------------------------------------------
-------------------------------
The Perl script that created the above is attached. It simply opens lots of
Postgres connections
2.1 The larger question?
The larger question is where the initialisation file is which holds
modifiable parameters that would aid
administration for a Postgres db.
The Oracle equivelant is the init<SID>.ora and config<SID>.ora
<<openDB.pl>>
openDB.pl
