RE: help for pg_wal issue - Mailing list pgsql-general

From Özge Özyavuz
Subject RE: help for pg_wal issue
Date
Msg-id 2448dce81d094556809987a8b65f64b5@softtech.com.tr
Whole thread Raw
In response to Re: help for pg_wal issue  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-general

Thanks a lot for your reply!

We used netbackup for postgresql backups.
From what I saw on pgadmin tool backup user first issue this command,

SELECT pg_start_backup('label',true)
Then tool copy the postgresql directory and its files.

Then it executed this command.
SELECT pg_stop_backup()

what I understand  from this document (https://www.postgresql.org/docs/devel/continuous-archiving.html#BACKUP)  it
shouldbe right below, for backing up all wall files?
 
pg_backup_stop(wait_for_archive => true);

Am I right?

Thanks a lot.



Özge Özyavuz
Mimar
Profesyonel Hizmetler

www.softtech.com.tr




_____________________________________________________

Bu e-posta mesajı ve ekleri gönderildiği kişi ya da kuruma özeldir ve gizlidir. Ayrıca hukuken de gizli olabilir.
Hiçbirşekilde üçüncü kişilere açıklanamaz ve yayınlanamaz. Mesajın yetkili alıcısı değilseniz hiçbir kısmını
kopyalayamaz,başkasına gönderemez veya hiçbir şekilde kullanamazsınız. Eğer mesajın yetkili alıcısı veya yetkili
alıcısınailetmekten sorumlu kişi siz değilseniz, lütfen mesajı sisteminizden siliniz ve göndereni uyarınız. Gönderen ve
SOFTTECHA.Ş., bu mesajın içerdiği bilgilerin doğruluğu, bütünlüğü ve güncelliği konusunda bir garanti vermemektedir.
Mesajıniçeriğinden, iletilmesinden, alınmasından, saklanmasından, gizliliğinin korunamamasından, virüs içermesinden ve
sisteminizdeyaratabileceği zararlardan şirketimiz sorumlu tutulamaz.
 

This e-mail and its attachments are private and confidential to the exclusive use of the individual or entity to whom
itis addressed. It may also be legally confidential. Any disclosure, distribution or other dissemination of this
messageto any third party is strictly prohibited. If you are not the intended recipient, you may not copy, forward,
sendor use any part of it. If you are not the intended recipient or the person who is responsible to transmit to the
intendedrecipient, please contact the sender by reply e-mail and destroy all copies of the original message and its
attachments.The sender and SOFTTECH A.S. do not warrant for the accuracy, currency, integrity or correctness of the
informationin the message and its attachments. SOFTTECH A.S. shall have no liability with regard to the information
containedin the message, its transmission, reception, storage, preservation of confidentiality, viruses or any damages
causedin anyway to your computer system.
 


-----Original Message-----
From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Sent: Tuesday, June 28, 2022 10:32 AM
To: laurenz.albe@cybertec.at
Cc: Özge Özyavuz <Ozge.Ozyavuz@softtech.com.tr>; pgsql-general@lists.postgresql.org
Subject: Re: help for pg_wal issue

At Tue, 28 Jun 2022 16:28:31 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in
> At Mon, 27 Jun 2022 12:28:18 +0200, Laurenz Albe
> <laurenz.albe@cybertec.at> wrote in
> > You forgot to tell us how exactly you are performing that backup.
>
> Yeah, but Google told me that Veritas may complain with that message.
> Anywhat the tools is, it seems like that the tool could not continue
> after it found that a file had been deleted before copying it. That
> means the server is live.  If you take a copy of files from a live
> server, the backup tool should allow some files are removed or added
> while copying.
>
> If you are taking a base backup (aka online backup), you need to take
> several subsidiary steps.
>
> https://www.postgresql.org/docs/devel/continuous-archiving.html#BACKUP
> -LOWLEVEL-BASE-BACKUP
>

- If you still see the point, feel free to ask further here but with

Mmm.. My fingers are fat and eyes are slipperly.

+ If you don't still see the point, feel free to ask further here but
+ with

> showing exactly how you are peforming that backup:p
>
> regards.
>
> --
> Kyotaro Horiguchi
> NTT Open Source Software Center

--
Kyotaro Horiguchi
NTT Open Source Software Center

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: User's responsibility when using a chain of "immutable" functions?
Next
From: DAN LU
Date:
Subject: Question on pg_auto_failover extension