[GENERAL] Cluster Up-time.

Hello, Is there a table/view available from where I can check what time the cluster was started? Need this to calculate the uptime of the cluster. Or is there something else that I need to do in order to calculate this? Any help on this is appreciated. Cheers! Alexi Send instant messages to y

[GENERAL]

Thank you Michael! I have another question - related to this. If I make changes to the postgresql.conf and then do a 'pg_ctl reload', how do I get the date & time of this event? Cheers! Alexi Gen On Mon, Aug 18, 2008 at 03:53:32AM -0700, Alexi Gen wrote: > Is there a table/vi

[GENERAL] Time of 'pg_ctl reload'.

Thank you Michael! I have another question - related to this. If I make changes to the postgresql.conf and then do a 'pg_ctl reload', how do I get the date & time of this event? Cheers! Alexi Gen On Mon, Aug 18, 2008 at 03:53:32AM -0700, Alexi Gen wrote: > Is there a table/vi

[GENERAL] Newbie questions (pg_global, tablespace, pg_temp, ...)

Hello, I'm new to postgreSQL (not databases) and trying to find my way arouund. Have a couple of questions: (a) In which dir is the pg_global stored? Is it "C:\Program Files\PostgreSQL\8.2\data\global"? (b) Why is the pg_tablespace.spclocation column=null for pg_default & pg_global? (c) When

[GENERAL] Newbie questions (pg_global, tablespace, pg_temp, ...)

Hello, I'm new to postgreSQL (not databases) and trying to find my way arouund. Have a couple of questions: (a) In which dir is the pg_global stored? Is it "C:\Program Files\PostgreSQL\8.2\data\global"? (b) Why is the pg_tablespace.spclocation column=null for pg_default & pg_global? (c) When

[GENERAL] User privilege information.

Hello, How do I find out the privileges of a particular user? (names and ids of the objects and their permissions the user has access to) If there a single table/view that can give this information - please point me to it. Otherwise - give the names of the tables/views that contain this informa

[GENERAL] pg_tablespace.spcacl

Hello, pg_tablespace contains information about all the tablespaces available on the system. The [spcacl] column for a particular record - contains a string value of the names of users that have permissions on the tablespace. I'm looking for any info as to why this approach was taken? Can some

[GENERAL] information_schema.table_privileges

Am not able to understand 2 things about table_privileges and is_grantable. Can someone please help out with this? Create a table (acctmast). Check information_schema.table_privileges - there will not be any records for this table. Grant only SELECT permissions to a single user - (dbasr). A sin

[GENERAL] Role & User - Inheritance?

[GENERAL] Role & User - Inheritance? A ROLE dba01 has been given the option of SUPERSUSER. A USER user01 is created and tagged to the above ROLE dba01. When attempting to create a Tablespace (logged in as user01) it generates the following message: "permission denied to create tablespace (tblspc

[GENERAL]

Hello, I'm searching for instructions on installing PostgreSQL 8.1.4 on SLES 9 SP2. Can someone please point me to a web-site / document that has the proper set of instructions? Cheers _ Tried the new MSN Messenger? It’s cool! Do

[GENERAL] Location of \pgsql\src\test\regress\readme.

Hello, I've connected to the open-source community CVS and got the source code of PostgreSQL. According to the available documentation there is supposed to be a 'readme' file in the '\pgsql\src\test\regress\' folder. But from what I received after downloading using WinCVS - there was no read