python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Postgresql: Able to authenticate using psql but unable to backup with pg_dump
I have trouble backing up a PostgreSQL database. When I run the following command:
psql -d cdb -U "$(whoami)"
The result:
cdb=# \c
You are now connected to database "cdb" as user ...
Christian Hick
Votes: 0
Answers: 1
How to take pg dump from testing server to my pc
I am trying to take pg dump from testing server to my local machine, i have been logged into my server
root@myproject-staging-development1:~/myproject/current#
Which command should i write in here to ...
Azhar Sheikh
Votes: 0
Answers: 2
Dump from a managed postgresql instance with ssl and ssl mode required
Hello fellow programmers,
I am trying to dump from a postgres instance which is requiring me to connect with a ssl certificate. The problem that occurs is that the --sslcert and --sslmode that exists ...
Ms01
Votes: 0
Answers: 1
pg_dump on a specific schema outputs no tables and no data
mydb=# select version();
version
------------------------------------------------------------...
Bertie
Votes: 0
Answers: 1