Re: Recommended way to copy database files on Windows OS (to perform file system level backup)

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org,Allan Kamau <kamauallan(at)gmail(dot)com>,Yashwanth Govinda Setty <ygovindasetty(at)commvault(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>,Girish Rao <grao(at)commvault(dot)com>
Subject: Re: Recommended way to copy database files on Windows OS (to perform file system level backup)
Date: 2018-05-14 17:01:18
Message-ID: F0874CE9-1197-4C40-9E17-6816C5CF4295@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>An easy way to perform backup of your data is to use PostgreSQL's very
>own
>pg_dump utility.

That's not a file level backup, but a logical backup. Maybe he wants to build standby for streaming replication, for this you needs an other backup. See the answer from Christoph.

Andreas

--
2ndQuadrant - The PostgreSQL Support Company

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-05-14 17:16:26 Re: Rapid disk usage spikes when updating large tables with GIN indexes
Previous Message Jonathan Marks 2018-05-14 16:28:05 Rapid disk usage spikes when updating large tables with GIN indexes