You can use pg_dump to creating a backup.
pg_dump -U db_username db_name -f file_name.dump
On Thu, Sep 17, 2015 at 1:45 PM, Albe Laurenz
wrote:
> John R Pierce wrote:
> > to copy the data directory and have it be useful you need to bracket the
> copy with calls to
> > pg_start_backup() and pg_s
John R Pierce wrote:
> to copy the data directory and have it be useful you need to bracket the copy
> with calls to
> pg_start_backup() and pg_stop_backup() this ensures the data files are
> coherent. this is in
> fact what pg_basebackup does for you
I apologize for my fussiness, but
On 9/17/2015 12:31 AM, Raman, Karthik IN BLR STS wrote:
I need a small clarification. We are using PostgreSQL version 9.4.1
We have a requirement to take the online backup of a running
PostgreSQL system (with out stopping the database).
As per the design / architecture of PostgreSQL system, is i
Hi All,
I need a small clarification. We are using PostgreSQL version 9.4.1
We have a requirement to take the online backup of a running PostgreSQL system
(with out stopping the database).
As per the design / architecture of PostgreSQL system, is it technically
allowed to dynamically copy the "
