Re: Unable to execute pg_dump

2020-06-14 Thread Tom Lane
Joseph Maruca writes: > I end up in the bash-4.1 shell. When executing the following command from > within the shell: bash-4.1$ pg_dump db_name > /tmp/my_database.sql I am > presented with the following error: > pg_dump: [archiver (db)] connection to database "db_name" failed: could not > conn

Re: Unable to execute pg_dump

2020-06-14 Thread David G. Johnston
On Sunday, June 14, 2020, Joseph Maruca wrote: > > '''sudo -u postgres -H --psql -px -d db_name''' > > If I enter the following syntax from the RHEL command line: > > '''sudo su postgres''' > > I end up in the bash-4.1 shell. When executing the following command from > within the shell: bash-4

Unable to execute pg_dump

2020-06-14 Thread Joseph Maruca
Hello everyone, I am trying to work out a way to perform a PostgreSQL pg_dump of a single DB via RHEL v6.10 command line. Now the system I am working on is that you have to shell into Bash 4.1 first before you get to PSQL. Now I can access the actual PSQL db using the following syntax from the