pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
version control based configuration in Postgresql
5+ messages / 4 participants
[nested] [flat]

* version control based configuration in Postgresql
@ 2023-07-03 10:18  Nikhil Ingale <niks.bgm@gmail.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Nikhil Ingale @ 2023-07-03 10:18 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

Hi All,
I would like to know how to perform version control based configuration
backup for the postgresql database.

Regards,
Nikhil Ingale

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: version control based configuration in Postgresql
@ 2023-07-03 10:50  Licio Matos <licio.matos@gmail.com>
  parent: Nikhil Ingale <niks.bgm@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Licio Matos @ 2023-07-03 10:50 UTC (permalink / raw)
  To: Nikhil Ingale <niks.bgm@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

Hi!

You can use such tools like liquidbase or flyway.
You can track DDL/DML scripts and versioning in some git tools either.

Licio Matos

Em seg., 3 de jul. de 2023 às 07:19, Nikhil Ingale <niks.bgm@gmail.com>
escreveu:

> Hi All,
> I would like to know how to perform version control based configuration
> backup for the postgresql database.
>
> Regards,
> Nikhil Ingale
>
-- 
Licio Matos

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: version control based configuration in Postgresql
@ 2023-07-03 10:56  Nikhil Ingale <niks.bgm@gmail.com>
  parent: Licio Matos <licio.matos@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Nikhil Ingale @ 2023-07-03 10:56 UTC (permalink / raw)
  To: Licio Matos <licio.matos@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

Okay, Does BARMAN and BART tools support version control configuration?

On Mon, Jul 3, 2023 at 4:20 PM Licio Matos <licio.matos@gmail.com> wrote:

> Hi!
>
> You can use such tools like liquidbase or flyway.
> You can track DDL/DML scripts and versioning in some git tools either.
>
> Licio Matos
>
> Em seg., 3 de jul. de 2023 às 07:19, Nikhil Ingale <niks.bgm@gmail.com>
> escreveu:
>
>> Hi All,
>> I would like to know how to perform version control based configuration
>> backup for the postgresql database.
>>
>> Regards,
>> Nikhil Ingale
>>
> --
> Licio Matos
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: version control based configuration in Postgresql
@ 2023-07-03 10:58  Holger Jakobs <holger@jakobs.com>
  parent: Nikhil Ingale <niks.bgm@gmail.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Holger Jakobs @ 2023-07-03 10:58 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

Am 03.07.23 um 12:18 schrieb Nikhil Ingale:
> Hi All,
> I would like to know how to perform version control based 
> configuration backup for the postgresql database.
>
> Regards,
> Nikhil Ingale

If it's about the postgresql.conf, pg_hba.conf, pg_ident_conf and files 
in the conf.d subdirectory, any version control system will do.

Whether it's git, bazaar, mercurial or fossil.

I version all my configurations (all of /etc) with https://fossil-scm.org

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012



Attachments:

  [application/pgp-signature] OpenPGP_signature (202B, ../../93533ffa-2dd7-2110-cbcb-6426037ea363@jakobs.com/2-OpenPGP_signature)
  download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: version control based configuration in Postgresql
@ 2023-07-03 12:59  Ron <ronljohnsonjr@gmail.com>
  parent: Nikhil Ingale <niks.bgm@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Ron @ 2023-07-03 12:59 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

Version control software was designed to control the versions of text 
files.  BarMan is configured using text files.

On 7/3/23 05:56, Nikhil Ingale wrote:
> Okay, Does BARMAN and BART tools support version control configuration?
>
> On Mon, Jul 3, 2023 at 4:20 PM Licio Matos <licio.matos@gmail.com> wrote:
>
>     Hi!
>
>     You can use such tools like liquidbase or flyway.
>     You can track DDL/DML scripts and versioning in some git tools either.
>
>     Licio Matos
>
>     Em seg., 3 de jul. de 2023 às 07:19, Nikhil Ingale
>     <niks.bgm@gmail.com> escreveu:
>
>         Hi All,
>         I would like to know how to perform version control based
>         configuration backup for the postgresql database.
>
>         Regards,
>         Nikhil Ingale
>
>     -- 
>     Licio Matos
>

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2023-07-03 12:59 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-03 10:18 version control based configuration in Postgresql Nikhil Ingale <niks.bgm@gmail.com>
2023-07-03 10:50 ` Licio Matos <licio.matos@gmail.com>
2023-07-03 10:56   ` Nikhil Ingale <niks.bgm@gmail.com>
2023-07-03 12:59     ` Ron <ronljohnsonjr@gmail.com>
2023-07-03 10:58 ` Holger Jakobs <holger@jakobs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox