Geek Answers Handbook

How to use pg_dump without using Heroku tools?

I want to use pg_dump in a pgSQL application with multiple Heroku schemas using the gem of an apartment, but I'm afraid that I have too many schemas to make it work.

I looked over it and found the following from the apartment gem maker on the next

I am the author of the gem in the apartment that is mentioned here. We have been using it for over a year at Heroku and uses circuits.

This is definitely great, we still get the excellent performance of over 100 schemas in an application with 50+ tables for each schema.

The article mentioned in @ 4ware talks about problems with the hero pg: backups. (I'm sure the article came from our support for querying them)

DEFINITELY has problems, but this is not a disadvantage of Postgresql, schemes, or multi-user mode with schemes, but rather the heroic tool itself. Now that Postgresql has ingres support for its dbs, you don't really need to use your built-in tools. We are just pg_dump when we need it and it works as fast as you would expect.

How can I use external tools? Can anyone clarify this?

+4
source share
1 answer

I do not know that this person means "Ingres" - of course, not a product, Ingres. Perhaps "inbound", i.e. "Incoming"?

: SSL- PostgreSQL Heroku , libpq. psql... pg_dump.

:

pg_dump -Fc -f mydb.dbbackup "sslmode=require host=my.heroku.host.name port=5432 dbname=my.heroku.db.name user=my.heroku.user"

( , ).

. Heroku.

, Heroku docs. , , Heroku Heroku:

pg_dump -Fc -f mydb.dbbackup $(heroku pg:credentials DATABASE)
+4

More articles:


All Articles