Saturday, June 4, 2022

Export / Import PostgreSQL to .sql file

 

Export postgreSQL to .sql file (linux):
# pg_dump -U username -h localhost databasename >> sqlfile.sql

Import .sql file into PostgreSQL database (windows / linux):
> psql -h localhost -U postgres -d postdata -f D:\Backup\database.sql

Posted by at
Labels:

1 comment:

  1. NasaDecember 27, 2023 at 2:36 AM

    psql -h localhost -U mytakmiruser -d mytakmirdb_231227 -f "D:\nextcloud-data2\JHEAINS\MyTakmirNS\Backup Database\Afizi\dump-mytakmirns-db-202312271639.sql" -W
    -W is to prompt password

    ReplyDelete

Subscribe to: Post Comments (Atom)