Step 2:<\/strong> Enter the following command using your keyboard and at the end, press enter\/return on your keyboard. Be sure to replace the ‘username’ with your cPanel default account username and replace ‘dbname’ with the name of the database you wish to export.<\/p>\n You will be prompted for your default cPanel user account password in order to complete the export.<\/p>\n \t\t \r\n \t\t\t\t\tYour database will be downloaded with the name dbexport.pgsql. You can change the name of the database to anything you want after saving the file, but don’t change the extension.\u00a0 \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t\n \t\t \r\n \t\t\t\t\tYou may receive an error message, similar to the ones below, when running this command.<\/p>\n These errors occur because some server database templates include PostGIS with restricted access permissions.<\/p>\n To export a PostgreSQL database without this data, type the following command instead of the command listed in step 2:<\/p>\n Step 1:<\/strong> Login to your cPanel. There’s a lot of ways to do this, but the sure fire easiest way is to login to your Client Area<\/a>, then open your cPanel.<\/p>\n Step 2:<\/strong> Scroll down to the Databases section and open phpPgAdmin.<\/p>\n Step 3:<\/strong> When phpPgAdmin opens, expand the Servers area from the left hand side, then expand PostgreSQL, and then click the name of the database you wish to export.<\/p>\n Step 4:<\/strong> From the menu at the top, click the Export button.<\/p>\n Under the Format column, select Structure and data. Under the Options column, in the Format list box, select SQL.<\/p>\n Then beneath Options, select Download.<\/p>\n Finally, click Export.<\/p>\n The file will be saved to your computer.<\/p>\n <\/p>\n Tired of experiencing issues with your site? Get the best and fastest hosting support with ChemiCloud!\u00a0<\/b>\ud83e\udd13<\/span> Check out our <\/b>web hosting<\/span> <\/b><\/span><\/a>plans!<\/b><\/p>\n <\/p>\n Before you can import a PostgreSQL database, you must create a new database in cPanel and assign a user to it.<\/p>\n \t\t \r\n \t\t\t\t\tYou should import all of your PostgreSQL databases as the primary PostgreSQL user, aka the username assigned to your cPanel account. If you import PostgreSQL databases as a regular user, you will be unable to see or manipulate the data properly using phpPgAdmin.<\/p>\n After you have imported the data as the primary PostgreSQL user, you can grant a regular user access to the database. Then you won’t need to use the primary domain username and password in scripts that access the database. \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t\n Step 1:<\/strong> Using SCP, SFTP, FTP, or the cPanel File Manager > Upload File tool, upload the database you want to import to your hosting account.<\/p>\n Step 2:<\/strong> Connect to your web hosting account<\/a> via SSH. If you are not familiar with how to do this, click here to review our KB article on the topic.<\/p>\n Step 3: Enter the following command, then press enter\/return on your keyboard. Replace ‘username’ with your cPanel username and replace ‘dbname’ with the name of the database you wish to import:<\/p>\n The ‘dbname’ database should now contain all the data that was in the database file you uploaded.<\/p>\n To import a PostgreSQL database using phpPgAdmin, follow the steps below:<\/p>\n Step 1:<\/strong> Login to your cPanel. There’s a lot of ways to do this, but the sure fire easiest way is to login to your Client Area<\/a>, then open your cPanel.<\/p>\n Step 2:<\/strong> Scroll down to the Databases section and open phpPgAdmin.<\/p>\n Step 3: From the left side of phpPgAdmin, expand the Servers area, then expand PostgreSQL, then click the name of the database you want to import data into.<\/p>\n Next click SQL from the row of options at the top of the page.<\/p>\n A white box will appear. You are able to enter text into this box, but you won’t need to. Instead, click the “Choose File” button beneath the text box.<\/p>\n When the file picker opens, choose the .postgresql file you wish to upload.<\/p>\n Then click Execute to instruct phpPgAdmin to import the data in that file into the database.<\/p>\n The official documentation for PostgreSQL can be very handy sometimes.<\/p>\npg_dump -U username dbname > dbexport.pgsql<\/pre>\n
pg_dump: SQL command failed \r\n\r\npg_dump: Error message from server: ERROR: permission denied for schema topology \r\n\r\npg_dump: The command was: LOCK TABLE topology.topology IN ACCESS SHARE MODE<\/pre>\n
pg_dump -U username dbname -N topology -T spatial_ref_sys > dbexport.pgsql<\/pre>\n \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t\n
Method #2 Use phpPGAdmin<\/h3>\n
![\"\"](\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2020\/12\/lab.jpg\")
<\/p>\n![\"\"](\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/1-783x211.jpg\")
<\/p>\n![\"\"](\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/2-783x177.jpg\")
<\/p>\n![\"\"](\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/3-783x167.jpg\")
<\/p>\n![\"\"](\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/4-1-783x248.jpg\")
<\/p>\nHow to import a PostgreSQL database<\/h2>\n
Method # 1: Use the psql application<\/h3>\n
psql -U username dbname < dbexport.pgsql<\/pre>\n
Method # 2: Use phpPgAdmin<\/h3>\n
<\/p>\n<\/p>\n![\"\"](\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/5-783x178.jpg\")
<\/p>\n![\"\"](\"https:\/\/chemicloud.com\/kb\/wp-content\/uploads\/2021\/04\/6-783x176.jpg\")
<\/p>\nAdditional Information<\/h2>\n