pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres Complete backup
5+ messages / 4 participants
[nested] [flat]
* Postgres Complete backup
@ 2019-01-30 06:19 Sridhara KB <sridhara.kb@digitalapicraft.com>
0 siblings, 2 replies; 5+ messages in thread
From: Sridhara KB @ 2019-01-30 06:19 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi,
How can i take postgres complete backup including users schema triggers etc…..
P.S currently running postgres 9.4
Thanks,
Sridhara K.b
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres Complete backup
@ 2019-01-30 06:25 Ron <ronljohnsonjr@gmail.com>
parent: Sridhara KB <sridhara.kb@digitalapicraft.com>
1 sibling, 1 reply; 5+ messages in thread
From: Ron @ 2019-01-30 06:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 1/30/19 12:19 AM, Sridhara KB wrote:
> Hi,
>
> How can i take postgres complete backup including users schema triggers etc…..
>
> P.S currently running postgres 9.4
https://www.postgresql.org/docs/9.6/app-pgdump.html
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres Complete backup
@ 2019-01-30 06:27 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Sridhara KB <sridhara.kb@digitalapicraft.com>
1 sibling, 0 replies; 5+ messages in thread
From: Shreeyansh Dba @ 2019-01-30 06:27 UTC (permalink / raw)
To: Sridhara KB <sridhara.kb@digitalapicraft.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
You can go with pg_dumpall or pg_basebackup.
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
On Wed, Jan 30, 2019 at 11:49 AM Sridhara KB <
sridhara.kb@digitalapicraft.com> wrote:
> Hi,
>
> How can i take postgres complete backup including users schema triggers
> etc…..
>
> P.S currently running postgres 9.4
>
>
> Thanks,
> Sridhara K.b
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres Complete backup
@ 2019-01-30 06:30 Sridhara KB <sridhara.kb@digitalapicraft.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Sridhara KB @ 2019-01-30 06:30 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi
Have gone through this url, but size of pgdata of old database and pgdata of new database are not matching.
Basically am doing migration activity from one instance pgsql9.4 to other instance pgsql 9.4
> On 30-Jan-2019, at 11:55 AM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> On 1/30/19 12:19 AM, Sridhara KB wrote:
>> Hi,
>>
>> How can i take postgres complete backup including users schema triggers etc…..
>>
>> P.S currently running postgres 9.4
>
> https://www.postgresql.org/docs/9.6/app-pgdump.html
>
>
> --
> Angular momentum makes the world go 'round.
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres Complete backup
@ 2019-01-30 06:36 Tom Lane <tgl@sss.pgh.pa.us>
parent: Sridhara KB <sridhara.kb@digitalapicraft.com>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2019-01-30 06:36 UTC (permalink / raw)
To: Sridhara KB <sridhara.kb@digitalapicraft.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
Sridhara KB <sridhara.kb@digitalapicraft.com> writes:
> Have gone through this url, but size of pgdata of old database and pgdata of new database are not matching.
That in itself means nothing.
A freshly-reloaded table will contain no dead space, and freshly-rebuilt
indexes typically have less bloat than ones that have been used for
awhile. So the fact that your new database is smaller per "du" does
not mean you lost data.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-01-30 06:36 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-30 06:19 Postgres Complete backup Sridhara KB <sridhara.kb@digitalapicraft.com>
2019-01-30 06:25 ` Ron <ronljohnsonjr@gmail.com>
2019-01-30 06:30 ` Sridhara KB <sridhara.kb@digitalapicraft.com>
2019-01-30 06:36 ` Tom Lane <tgl@sss.pgh.pa.us>
2019-01-30 06:27 ` Shreeyansh Dba <shreeyansh2014@gmail.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