Discussion:
checkpoint
Yves Dorfsman
2014-07-10 18:56:22 UTC
Permalink
Hi,

If I run checkpoint from psql, is it applied to all the databases?

What if I do it though an API? When connecting with psycopg2, I'm forced to
specify a database name, if I use "dbname=postgres", and execute
"checkpoint;", is it applied to all the databases?

Thanks.
--
Yves.
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Guillaume Lelarge
2014-07-10 19:02:50 UTC
Permalink
Post by Yves Dorfsman
Hi,
If I run checkpoint from psql, is it applied to all the databases?
What if I do it though an API? When connecting with psycopg2, I'm forced to
specify a database name, if I use "dbname=postgres", and execute
"checkpoint;", is it applied to all the databases?
Yes. CHECKPOINT is more a cluster-wide operation, rather than a database
one.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
Yves Dorfsman
2014-07-10 19:16:10 UTC
Permalink
Post by Yves Dorfsman
Hi,
If I run checkpoint from psql, is it applied to all the databases?
What if I do it though an API? When connecting with psycopg2, I'm forced to
specify a database name, if I use "dbname=postgres", and execute
"checkpoint;", is it applied to all the databases?
Yes. CHECKPOINT is more a cluster-wide operation, rather than a database one.
This is what I had observed, but wanted to be 100% sure. Thanks.
--
Yves.
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...