[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/view available from where I can check what time the cluster > was started? > Need this to calculate the uptime of the cluster. In PostgreSQL 8.1 and later you can run these queries to get the start time and uptime: SELECT pg_postmaster_start_time(); SELECT now() - pg_postmaster_start_time(); -- Michael Fuhr Send instant messages to your online friends http://uk.messenger.yahoo.com
[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/view available from where I can check what time the cluster > was started? > Need this to calculate the uptime of the cluster. In PostgreSQL 8.1 and later you can run these queries to get the start time and uptime: SELECT pg_postmaster_start_time(); SELECT now() - pg_postmaster_start_time(); -- Michael Fuhr Send instant messages to your online friends http://uk.messenger.yahoo.com
[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 your online friends http://uk.messenger.yahoo.com
[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 readme file. Can someone point me to a location from where I can ge the readme file OR instructions to do the regression tests on PostgreSQL. Cheers! _ Catch the complete World Cup coverage with MSN http://content.msn.co.in/Sports/Cricket/Default.aspx ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[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! Download now. http://messenger.msn.com/Download/Default.aspx?mkt=en-in ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 (tblspc01). Must be superuser to create a tablespace.". Since user01 is tagged to dba01 (who has the SUPERUSER option) - should'nt user01 also inherit this? If not - what benefit exists in grouping users under a Role? Cheers! _ Spice up your IM conversations. New, colorful and animated emoticons. Get chatting! http://server1.msn.co.in/SP05/emoticons/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
[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 single record appears for this relationship (acctmast - dbasr). Apart from the above there are 6 more records - all for the postgres user for the following (SELECT, DELETE, INSERT, UPDATE, REFERENCES, TRIGGER). (a) Why do these records appear only when the GRANT statement for the (acctmast - dbasr) is executed? They should have been displayed even before the GRANT was executed for dbasr. (b) [is_grantable] has a value of "NO". What is the meaning of this column and value? The documentation says that "YES if the privilege is grantable, NO if not". A Record appears in this table only AFTER the privilege has been granted. So why does "NO" appear in the column? Cheers! _ Catch the complete World Cup coverage with MSN http://content.msn.co.in/Sports/Cricket/Default.aspx ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 someone point me to a page / document? Cheers _ Get up-to-date with movies, music and TV. Its happening on MSN Entertainment http://content.msn.co.in/Entertainment/Default ---(end of broadcast)--- TIP 6: explain analyze is your friend
[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 information. Cheers sqlcatz _ Catch all the cricketing action right here. Live score, match reports, photos et al. http://content.msn.co.in/Sports/Cricket/Default.aspx ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 creating an object - if the tablespace attribute is not specified - it is resolved as follows: Index - Parent Table on which the index is being created. Table - Tablespace of the database in which the table is being created. Database - Tablespace of the template from which this database was created (Ex: template1). If the above is the method by which the tablespace name is resolved, when does the default_tablespace variable get used? Or Will the above come into the picture if default_tablespace=NULL? (d) The following objects are shared between all databases in a cluster. pg.catalog.pg_group: List of user groups (View). pg.catalog.pg_shadow: List of valid users. (View) pg.catalog.pg_database: List of databases in the cluster. (Table) pg.catalog.pg_tablespace: List of tablespaces. (Table) There are 33 tables & 33 Views in the pg_catalog schema. Are there any other tables & views that are common to all databases in a cluster? Why have cluster common objects sitting in each database in the cluster? How can we differentiate between objects in pg_catalog? Those that are specific to the database and those that are common to the cluster? (e) Can someone please point me to a document/URL that has information about using temp tables in postgreSQL? I have already read material that is available in the official PostgreSQL documentation. Want something more - the inner workings, pg_temp*, etc.. Cheers! sqlcatz _ Catch all the cricketing action right here. Live score, match reports, photos et al. http://content.msn.co.in/Sports/Cricket/Default.aspx ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[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 creating an object - if the tablespace attribute is not specified - it is resolved as follows: Index - Parent Table on which the index is being created. Table - Tablespace of the database in which the table is being created. Database - Tablespace of the template from which this database was created (Ex: template1). If the above is the method by which the tablespace name is resolved, when does the default_tablespace variable get used? Or Will the above come into the picture if default_tablespace=NULL? (d) The following objects are shared between all databases in a cluster. pg.catalog.pg_group: List of user groups (View). pg.catalog.pg_shadow: List of valid users. (View) pg.catalog.pg_database: List of databases in the cluster. (Table) pg.catalog.pg_tablespace: List of tablespaces. (Table) There are 33 tables & 33 Views in the pg_catalog schema. Are there any other tables & views that are common to all databases in a cluster? Why have cluster common objects sitting in each database in the cluster? How can we differentiate between objects in pg_catalog? Those that are specific to the database and those that are common to the cluster? (e) Can someone please point me to a document/URL that has information about using temp tables in postgreSQL? I have already read material that is available in the official PostgreSQL documentation. Want something more - the inner workings, pg_temp*, etc.. Cheers! sqlcatz _ Always wanted to be a writer? Here's your chance! http://content.msn.co.in/Contribute/Default.aspx ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq