Once the export is complete, your database file (e.g. When prompted, enter the database password. Replace export.sql with the path and name of the database you want to import: psql -h EXTERNAL_HOSTNAME -u USERNAME -P PORT -p DATABASE_NAME export.sql Use the following command to export the database, replacing EXTERNAL_HOSTNAME, USERNAME, PORT, and DATABASE_NAME with the information from your database’s External connections. You can find your database credentials under External connections on the database Info page. Use the PostgreSQL Yum repository and install the postgresql-client. RedHat-based Linus (RedHat Fedora, CentOS, etc.) Use the PostgreSQL APT repository and install the postgresql-client. With Homebrew, replace XX in the following command with the version of PostgreSQL you want to install: brew install Debian-based Linus (Debian, Ubuntu, Mint, etc.) Windowsĭownload and install the GUI installer or binaries for the Interactive installer by EDB. Depending on your operating system, you can install PostgreSQL in the following ways. If you do not yet have PostgreSQL installed on your local machine, you’ll need to install it to connect to your database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |