Move database from local server to remote server

Question

This is quite a general one, I'm trying to move a database from a local psql server on Windows to an AWS RDS server I've set up. The database is small, I'm really just doing it for the sake of learning how. The problems I'm having are as so:

-Seems like such a simple thing yet no simple solutions? (although I know/think if I had a linux system I could use pg_dump and cat dump. )

-I've gone into looking at aws documentation about how to migrate my database using their database migration service. However I've come to problems so early on that I'm close to believing it won't be worth the effort at my level of experience.

Seems like there must be a simple way and hoping the S/O community can help!

actually hold on, may have got it – Finn Maunsell May 15 '17 at 05:06 — Finn Maunsell, May 15 '17 at 05:06

score 1 · Accepted Answer · answered May 15 '17 at 05:24

1

Use some tool like PHPMyAdmin, use import to import your database dump to AWS RDS.

If you wish to use CLI, than use some FTP tool to upload dump to database, connect via SSH and use CLI to import this dump

answered May 15 '17 at 05:24

Justinas

41,402
5
66
96

Is there a phpMyAdmin for PostgreSQL? – Michael - sqlbot May 15 '17 at 10:45
@Michael-sqlbot Check here: http://stackoverflow.com/questions/5725216/postgresql-visual-interface-similar-to-phpmyadmin – Justinas May 15 '17 at 11:06
Right, so you might edit your answer accordingly, since the question does not appear to be about MySQL. (Note, I'm not the OP.) – Michael - sqlbot May 15 '17 at 11:56
I used adminer which is a psql version of PHPMyAdmin. – Finn Maunsell Aug 27 '17 at 07:57

Move database from local server to remote server

1 Answers1