10 ms·
Hi, just have a look here : http://phili.pe/posts/postgresql-on-the-command-line/ http://phili.pe/posts/postgresql-on-the-command-line/
by MitsuTomoe 11y ago
Hi, just have a look here : http://phili.pe/posts/postgresql-on-the-command-line/ http://phili.pe/posts/postgresql-on-the-command-line/
- yAnonymous 11y agoThat's the link in this post so yeah, I read that. It covers most of the stuff that happens inside the Postgres CLI which is good, but I also need to know about the things I can do directly from the Linux shell. How to backup a Postgres DB? mysqldump -u user -p DB > dump.sql Import a DB from the Linux command line? mysql -u user -p DB < dump.sql How to run a command directly from a shell script? mysql -u [user] -p[pass] -e "[mysql commands]" When managing systems, this stuff is more important to me than the actual Postgres syntax.
- AlterEgo20 11y agoBackup: http://www.postgresql.org/docs/current/static/app-pgdump.html http://www.postgresql.org/docs/current/static/app-pgdump.htm... In short: pg_dump -Fc mydb > db.dump Restore: http://www.postgresql.org/docs/current/static/app-pgrestore.html http://www.postgresql.org/docs/current/static/app-pgrestore.... In short: pg_restore -C -d postgres db.dump Command directly from the shell: psql -c "psql command"
- y4mi 11y agoand the default dumps are simple sql files, which you can actually pipe to another server. pg_dump -C mydb | psql -h ${some_other_server} mydb