Tagged Questions
0
votes
3answers
354 views
Export Postgres table on remote server to CSV file on local machine?
I have access to DB on remote server where I can do only select command,
So, I can execute:
COPY products TO '/tmp/products.csv' DELIMITER ',';
But on that server I don't have permission to ...
1
vote
1answer
101 views
Slow queries to remote PostgreSQL db
I am running a Drupal site that is backed by Postgres. This is my first time running something with Postgres; I come from the MySQL world.
For doing dev work on the site, I connect to a VPN and ...
0
votes
1answer
433 views
I would like to launch a pg_dump command from a remote computer
I would like to launch the command: pg_dump.exe -h 255.255.255.255 -p 5432 -U postgres -F p -a -v -f "test.db.dump" mydb from a remote computer. Both the database and the remote computer are under xp.
...
3
votes
3answers
704 views
How to connect to remote PostgreSQL server
I wrote a web app, using java + spring+ PostgreSQL, which I have up and running.
I have a tester for my system and I want him to be able to connect to my database directly to check the result of ...
