If you are looking forward to migrating\u00a0your PostgreSQL database to\u00a0AWS\u00a0EC2 cloud servers, you can do so by following the simple steps we have posted below. You can make it\u00a0more reliable and secure from accidental\u00a0 EC2 instance crashing by allowing the postgresql server to run from\u00a0an EBS volume. You can also take\u00a0 a snapshot of the EBS volume which will be stored on AWS storage service s3 which will\u00a0 make it highly reliable by making it available\u00a0on multiple\u00a0AWS availability zones that spans across datacenters.<\/p>\n
1 )<\/strong> Sign up for AWS\u00a0\u00a0\u00a0 EC2<\/a> and\u00a0 S3<\/a> services .<\/p>\n 2 )<\/strong> Launch an EC2\u00a0 instance using AWS\u00a0 EC2\u00a0 API <\/a> tool\u00a0 or\u00a0 GUI’s\u00a0 like\u00a0 Elastic fox<\/a> or\u00a0 AWS \u00a0 Management Console<\/a><\/p>\n 3 ) <\/strong>Launch an EBS\u00a0 and attach it to the instance<\/p>\n 4)<\/strong> Check if the attached EBS\u00a0 is present on the instance<\/p>\n [bash]fdisk -l[\/bash]<\/p>\n if \/dev\/sdh is the name of the EBS volume , it will be present without a valid partition table , so format the\u00a0 EBS volume\u00a0 .<\/p>\n [bash]mkfs\u00a0 -t ext3\u00a0 \/dev\/sdh\u00a0\u00a0\u00a0 ( or\u00a0\u00a0 mkfs.ext3 \/dev\/sdh )[\/bash]<\/p>\n 5 )<\/strong> Create a directory\u00a0 \/ebs\u00a0 and mount the EBS volume to\u00a0\u00a0 it<\/p>\n [bash] 6 ) <\/strong>Install postgresql server<\/p>\n [bash]yum\u00a0 install\u00a0\u00a0 postgresql-libs\u00a0\u00a0 postgresql\u00a0\u00a0\u00a0 postgresql-server[\/bash]<\/p>\n 7 ) <\/strong> Create\u00a0 a\u00a0 new data directory\u00a0 for postgresql\u00a0 database\u00a0 in EBS volume<\/p>\n [bash]mkdir \/ebs\/pgsql[\/bash]<\/p>\n 8 ) <\/strong> Stop Postgresql server if it is already running on your instance<\/p>\n [bash]\/etc\/init.d\/postgresql\u00a0\u00a0 stop[\/bash]<\/p>\n 9 )<\/strong> Move the Postgresql data\u00a0 directory to the EBS volume<\/p>\n [bash]mv \/var\/lib\/pgsql\u00a0 \/ebs[\/bash]<\/p>\n 10)<\/strong> Edit the init script\u00a0 for Postgresql\u00a0 and give the correct path for\u00a0 PGDATA and PGLOG<\/strong><\/p>\n [bash] 11 )<\/strong> Edit\u00a0 Postgresql\u00a0 configuration files\u00a0 to give access to database client , database , & database user .<\/p>\n [bash] 12)<\/strong> Start the Postgresql server<\/p>\n [bash] \/etc\/init.d\/postgresql start[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":" If you are looking forward to migrating\u00a0your PostgreSQL database to\u00a0AWS\u00a0EC2 cloud servers, you can do so by following the simple steps we have posted below. You can make it\u00a0more reliable and secure from accidental\u00a0 EC2 instance crashing by allowing the postgresql server to run from\u00a0an EBS volume. You can also take\u00a0 a snapshot of the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[34,3],"tags":[235,221,20,127,215,41,624,23,233],"class_list":["post-114","post","type-post","status-publish","format-standard","hentry","category-amazon-ec2","category-cloud-computing","tag-amazon-elastic-compute-cloud","tag-amazon-web-services","tag-aws","tag-cloud-computing","tag-cloud-infrastructure","tag-ebs","tag-eucalyptus","tag-postgresql-database-ebs-ec2-amazon-aws-cloud-computing","tag-web-services"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
\nmkdir\u00a0 \/ebs
\nmount \/dev\/sdh \/ebs
\n[\/bash]<\/p>\n
\nvi\u00a0\u00a0 \/etc\/init.d\/postgresql
\nPGDATA=\/ebs\/pgsql
\nPGLOG=\/ebs\/pgsql\/pgstartup.log
\n[\/bash]<\/p>\n
\nvi\u00a0\u00a0 \/ebs\/pgsql\/data\/pg_hba.conf
\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0 10.250.51.0\/32\u00a0\u00a0 trust
\nvi\u00a0 \/ebs\/pgsql\/data\/postgresql.conf
\nlisten_addresses = ‘*’
\nport = 5432
\n[\/bash]<\/p>\n