Looking at alternative computer software solutions for a variety of reasons. This includes price, computer security, virus prevention and reliability. Here are my notes and great that if it helps you, otherwise please understand what you are doing and not follow blindly. All works expressed are my own and does not necessarily express the products or organisations mentioned here.
Notes for Postgresql 11,12
This approach allows an SQL file to be copied to a destination server and install using that sql file.
On the source server
pg_dump -C -Fp -f dump.sql -U postgres database_name
Copy the file dump.sql to the destination server. On the destination server
psql -U postgres -f dump.sql
No comments:
Post a Comment