Thread: checkpoint
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.
2014-07-10 20:56 GMT+02:00 Yves Dorfsman <yves@zioup.com>:
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.
--
On 2014-07-10 13:02, Guillaume Lelarge wrote: > 2014-07-10 20:56 GMT+02:00 Yves Dorfsman <yves@zioup.com <mailto:yves@zioup.com>>: > > > 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.