agora inbox for pgsql-admin@postgresql.orghelp / color / mirror / Atom feed
restore time 2+ messages / 2 participants [nested] [flat]
* restore time @ 2003-04-02 20:22 lists <lists@insyde.com.br> 0 siblings, 0 replies; 2+ messages in thread From: lists @ 2003-04-02 20:22 UTC (permalink / raw) To: pgsql-admin Hi, I'm trying to restore a database, btu I couldn't so far. It's taking more than 14 hours to complete, and we make a valuation of more than 22 hours to complete restore a 1,5 Gb database, from a 60 mb dump. This only happen when I use the binary mode (-Fc) with plain text it takes at most 3 hours. I need this mode because of the lo types. Is anyone having this kind of problem? How long your dump/restore takes to complete? What's the size of the DB? Is there any workaround? TIA, Ricardo. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Restore time @ 2025-03-31 13:42 Raj <rajeshkumar.dba09@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Raj @ 2025-03-31 13:42 UTC (permalink / raw) To: Pgsql-admin <pgsql-admin@lists.postgresql.org> I have openshift, postgres 15.6, I set up DR (repo based dr - s3). Once I take a backup from openshift cluster1 to repo2 s3 bucket, I want to use that backup and set up DR in openshift cluster2. Now, my question is, if the size of db is 300gb, will it take time to restore it or It can immediate start as standby ? ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-03-31 13:42 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-04-02 20:22 restore time lists <lists@insyde.com.br> 2025-03-31 13:42 Restore time Raj <rajeshkumar.dba09@gmail.com>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox