backup to partitioned table

From: Erik Serrano <eserranos(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: backup to partitioned table
Date: 2022-11-16 15:56:37
Message-ID: CA+dvXXt=G+a=4C5j8rn9ZTjP+g-6tu3MtnMC0cKbWSH5Nk5ovA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Guys,
I have a case that I would like you to help me with.

I have a partitioned table in postgresql version 9,5 to which I select and
it returns data perfectly, but when I want to make a backup of the table,
it only saves the structure without records.
It should be noted that I am not making a backup of the structure, but of
the data or complete, but it does not back up the data anyway.
When consulting the administrator, he informs me that it is a partitioned
table and that it is always zero, but the data is in its "daughter" tables
and that the select that it returns is the information that is housed in
all its daughter tables.

Now, given this, I wanted to know if there is any way to make a backup of
the table that throws all the data from its child tables into a flat file.

Is it possible to perform this action?
From already thank you very much

Cheers

*Erik R. Serrano Saavedra*
*Ingeniero de Sistemas Informáticos*
* Data Base Administrator*

* eserranos(at)gmail(dot)com <eserranos(at)gmail(dot)com>*
* 998596691*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2022-11-16 16:04:16 Re: backup to partitioned table
Previous Message Dhirendra Singh 2022-11-16 05:45:12 Re: does postgres support certificate file in p12 format ?