[ADMIN] How to check history of sequences and constraints (version 9.1)

Hi Experts, I want to check the last reset valued of sequence and the date of foreign key constraint when it was created. Is that possible in postgres 9.1 version?? Please help me on that.

Re: [ADMIN] Resolving Index Bloat

Thanks, Greg. I may look at running a scheduled REINDEX. Sam -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Greg Williamson Sent: Tuesday, 20 November 2012 10:11 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Res

Re: [ADMIN] No databases visible on pg 8.3 server

Thanks Craig, I've already done that. On 11/11/2012 9:15 PM, Craig Ringer wrote: On 11/11/2012 08:27 AM, Pat Heuvel wrote: 2012-11-05 23:03:07 EST LOG: could not open file "pg_xlog/00010285002E" (log file 645, segment 46): No such file or directory If you haven't already, before

Re: [ADMIN] No databases visible on pg 8.3 server

Gday Lukasz, You're right - the service does run. However, no databases are visible. I would love to be able to do a pg_dump/restore! Can you tell me what might make postgresql think there are no databases when the file pg_database and the file 1262 both show databases? This is running on a