On Fri, Jul 19, 2019 at 12:22:36PM +0530, shaurya jain wrote:
> My concern is so simple that the below command is taking full instance
> backup in version 10 and in 11 it is taking only Postgres DB backup.
>
> pg_dump -U postgres -Fc >> all_db_04_07_2019.dump --verbose
>
> Kindly suggest me some way to take full instance back up and restore a
> particular DB.
Please do not top-post. This is not the style of the PostgreSQL
community mailing lists.
I am afraid that you still are giving zero clue about what is going
wrong. Giving a command does not help. Giving information about the
error happening does help, and pg_dump reports any errors when it
normally words, even if you use incorrect credentials to connect to
PostgreSQL. Are you sure for example that your database user is the
correct one? Without this information, nobody will be able to
understand what is wrong and help you. If you do not know how to
capture errors from stderr, well...
--
Michael
