![]() Learn more in PostgreSQL’s SQL Dump documentation. The redirection to save the database dump to a file called your_dump_file.pgsql. The -Fc flags to create the dump file in the custom format, compatible with pg_restore. Our managed databases require connecting to port 25060. ![]() The -p flag to specify a connecting port. The -U flag to specify the admin user on the existing database. The -h flag to specify the IP address or hostname, if using a remote database. To use pg_dump, you need specify the connection details (like admin username and database) and redirect the output of the command to save the database dump. pg_dumpall is a similar utility meant for PostgreSQL database clusters. One method of exporting data from an existing PostgreSQL database is using pg_dump, a PostgreSQL database backup utility. You can use the default database or create a new database. If you have a PostgreSQL database that you want to import into DigitalOcean Managed Databases, you need the following:Īn export of the existing database, which you can get using pg_dump or other utilities.Ī PostgreSQL database cluster created in your DigitalOcean account.Īn existing database in the database cluster to import your data into. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more. PostgreSQL is an open source, object-relational database built with a focus on extensibility, data integrity, and speed.
0 Comments
Leave a Reply. |