[ADMIN] possible bug with sequences

2004-04-05 Thread Victor Sudakov
eq'::text) name | text| == cut here = Voila! pg_restore will now return an error on trying to execute SELECT pg_catalog.setval('sometable_id_seq', 4, true); because this sequence has not been created either explicitly or implicitly! It is 100% reproducible on post

Re: [ADMIN] automatic pg_dumpall

2004-03-26 Thread Victor Sudakov
sions and other information in this message represent the > opinion of the sender and do not necessarily represent or reflect the views and > opinions of Ferring. > ** > > > ---(end of b

[ADMIN] automatic pg_dumpall

2004-03-25 Thread Victor Sudakov
. -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005/[EMAIL PROTECTED] http://vas.tomsk.ru/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [ADMIN] getting postgresql-7.4.1 statistics

2004-02-14 Thread Victor Sudakov
ppropriate >> > subscribe-nomail command to [EMAIL PROTECTED] so that your >> > message can get through to the mailing list cleanly By the way this advice does not work. Majordomo says: The command mode "nomail" is invalid. -- Victor Sudakov, VAS4

[ADMIN] getting postgresql-7.4.1 statistics

2004-02-12 Thread Victor Sudakov
Colleagues, How do I get the postgresql statistics? I would like to know queries per second etc. The stats_start_collector variable is on, and I can see the stats collector process running. But how do I query it? Thanks a lot for any input. -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005