# Moving Site and DB **URL:** \ **Category:** Rails\ **Created:** [June 4, 2008, 6:51pm UTC](https://www.ruby-forum.com/t/moving-site-and-db/139529 "2008-06-04T18:51:37Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![OhMyRuby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/0ea827/32.png) [@OhMyRuby](https://www.ruby-forum.com/u/OhMyRuby)\ **Post date:** [June 4, 2008, 6:51pm UTC](https://www.ruby-forum.com/t/moving-site-and-db/139529/1 "2008-06-04T18:51:37Z")
I have a site and postgresql db that i set up on 1 server. i have just created a new ruby server. does anyone have tutorial on how to move the application to another server? is a simple matter of copy the application folder and the db and moving them? will i have permission issues etc. thanks ---
**Author:** ![OhMyRuby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/0ea827/32.png) [@OhMyRuby](https://www.ruby-forum.com/u/OhMyRuby)\ **Post date:** [June 4, 2008, 7:01pm UTC](https://www.ruby-forum.com/t/moving-site-and-db/139529/2 "2008-06-04T19:01:45Z")
On 4 Jun 2008, at 17:51, OhMyRuby wrote: > I have a site and postgresql db that i set up on 1 server. > i have just created a new ruby server. > > does anyone have tutorial on how to move the application to another > server? > > is a simple matter of copy the application folder and the db and > moving them? As long as the new box has everything necessary installed, dumping the database & copying the application should be enough (Depending on how the database controls access to it, you may need to recite whatever incantations are needed to grant a user access to the db. Fred ---
**Author:** ![OhMyRuby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/0ea827/32.png) [@OhMyRuby](https://www.ruby-forum.com/u/OhMyRuby)\ **Post date:** [June 12, 2008, 5:16pm UTC](https://www.ruby-forum.com/t/moving-site-and-db/139529/3 "2008-06-12T17:16:40Z")
@frederick - thanks for your help. i was able to move the app but the database is not that easy. if anyone here is using postgresql please let me know how i can do this. i can shut the old server down to move the files. On Jun 4, 10:00 am, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![OhMyRuby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/0ea827/32.png) [@OhMyRuby](https://www.ruby-forum.com/u/OhMyRuby)\ **Post date:** [June 12, 2008, 6:06pm UTC](https://www.ruby-forum.com/t/moving-site-and-db/139529/4 "2008-06-12T18:06:14Z")
On 12 Jun 2008, at 16:16, OhMyRuby wrote: > @frederick - thanks for your help. > i was able to move the app but the database is not that easy. > > if anyone here is using postgresql please let me know how i can do > this. > i can shut the old server down to move the files. > **[Chapter 26. Backup and Restore](https://www.postgresql.org/docs/8.3/backup.html)** > > Chapter 26. Backup and Restore Table of Contents 26.1. SQL Dump 26.1.1. Restoring the Dump 26.1.2. Using pg\_dumpall 26.1.3. Handling Large Databases … Fred ---
**Author:** ![OhMyRuby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/0ea827/32.png) [@OhMyRuby](https://www.ruby-forum.com/u/OhMyRuby)\ **Post date:** [June 12, 2008, 6:18pm UTC](https://www.ruby-forum.com/t/moving-site-and-db/139529/5 "2008-06-12T18:18:00Z")
read this fredrick but couldn’t get it to work. i don’t mean to discuss postgresql in this forum, i was just hoping that a ruby user here that is using postgresql could quickly lead me down the right path. set up is from robby russels postgresql set up instructions. On Jun 12, 9:05 am, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![OhMyRuby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/0ea827/32.png) [@OhMyRuby](https://www.ruby-forum.com/u/OhMyRuby)\ **Post date:** [June 14, 2008, 3:45am UTC](https://www.ruby-forum.com/t/moving-site-and-db/139529/6 "2008-06-14T03:45:22Z")
Anyone using postgresql with Ruby?