pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_hba.conf is corrupt 2+ messages / 2 participants [nested] [flat]
* pg_hba.conf is corrupt @ 2018-08-24 22:40 Ron <ronljohnsonjr@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Ron @ 2018-08-24 22:40 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> completely overwritten by binary data. Been this way for 9 months, and we retain backups for 6 months. Is there any way to query postgres to regenerate this data? v8.4, if it matters. (Yes, it's archaic; yes, we're migrating.) Thanks. -- Angular momentum makes the world go 'round. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_hba.conf is corrupt @ 2018-08-24 22:48 Tom Lane <tgl@sss.pgh.pa.us> parent: Ron <ronljohnsonjr@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2018-08-24 22:48 UTC (permalink / raw) To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> Ron <ronljohnsonjr@gmail.com> writes: > completely overwritten by binary data. Been this way for 9 months, and we > retain backups for 6 months. > Is there any way to query postgres to regenerate this data? Nope, sorry. PG doesn't ever write that file, and it doesn't keep spare copies for you. If you haven't shut down the postmaster, it's possible that you could gdb into the postmaster (blocking connection attempts :-() and dig around in the postmaster's data structures to reconstruct the info. But that's probably impractical unless you have debug symbols for the server, and even with that it'd be pretty tedious and easy to mess up. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-08-24 22:48 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-08-24 22:40 pg_hba.conf is corrupt Ron <ronljohnsonjr@gmail.com> 2018-08-24 22:48 ` Tom Lane <tgl@sss.pgh.pa.us>
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