Re: [ADMIN] possible Bug in windows version ?

ections would not go out through the network and would thus not be seen by PG as coming from your 192/168 address. P. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] Lost password...

Mike wrote: Thanks for the tip. Changing the password is the easy part. What I don't understand is the consequences of changing that password and how it affects the 8.0 installation. Again, thanks for the tip. This piece of software is a handy thing to know. - Original Message Fr

Re: [ADMIN] Capacity of Data

Saji Verghese* *91-9941140433* ** http://www.postgresql.org/about/ -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Postgres error

ol manager is it started? If you look in task manager are there any postmaster.exe's running? -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Postgres error

lost write permissions to the directory. (E:/crisilfe/crisil/pgsql/data) -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Deletes hurt

g multiple rows with the same data, with one being current and the rest deleted - but that's not an issue in my system. If it's deleted it's deleted, it doesn't get recreated, but can be restored, thus not using an actual delete fits my scenario quite well. -- Paul La

Re: [ADMIN] Upgrading a database with pg_dumpall / psql ...

when I try and use COPY ... Perhaps in your old install standard_conforming_strings was set to off? Where in your new 8.2 install it is on by default. Check the postgresql.conf settings in your new install comparing against your 8.1 install, probably find some things particularly in the platf

[ADMIN] New server configuration

I'm curious to know what some might suggest are the best settings for resource usage (shared buffers, maintenance_work_mem etc) WAL and autovacuum - I can dedicate basically as much of the system resources to PG as it would need for best performance. TIA, P. -- Paul Lambert Database Adm

Re: [ADMIN] New server configuration

Paul Lambert wrote: I've got a new server which I'm looking for some assistance on determining the best configuration for PostgreSQL. It's the first time I've had to set up a new PG server from scratch and it has very different specs to our other servers which I don&#

[ADMIN] Schema security

cess to them or is there an easier way of doing it? Something like a "GRANT CASCADE" option? Cheers, P. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore yo

Re: [ADMIN] Schema security

Rodrigo De León wrote: You could use pgAdmin's Grant Wizard. That doesn't help in scripting... -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an a

Re: [ADMIN] Schema security

Tom Lane wrote: Paul Lambert <[EMAIL PROTECTED]> writes: I would have thought giving the user all privileges on a schema would by default add them to all objects within it, Why would you think that? The analogy to think about is that usage privilege on a schema is comparable to read

[ADMIN] PGSQL manager password lost.

ve to wade through a few thousand lines of SQL to make it workable in M$. Is is possible to pipe table structures/views through an ODBC connection? Is this something I should be asking on M$ forums? -- Paul Lambert Database Administrator Infomedia Ltd. - Business Systems Division Email: [EMAIL PROTE