Postgres DB hacked. - Mailing list pgsql-general

From Yogesh Sharma
Subject Postgres DB hacked.
Date
Msg-id CAEZUwCQDPCOtSRBuu4uj1YKM31V1w63RH=xxtqdhccYMaG09cw@mail.gmail.com
Whole thread Raw
Responses Re: Postgres DB hacked.  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Postgres DB hacked.  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Dear All,
Thanks for your support.

We faced the below issue and our all DB backup data has lost.

 It seems Hacker deleted all the tables in the DB and created a single table called "warning". when I am trying to select this table so it's showing Error (relation "warning" does not exist). Hacker created one more database  "please_read_me_xmg" with single 'warning' table.  

Could you please let us know how we   can secure postgres DB from hackers.Although we have specified only one IP in pg_hba.conf file instead of all.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Request clarification w/ PG_DUMPALL -d.
Next
From: Pavel Stehule
Date:
Subject: Re: Postgres DB hacked.