AWS has a free tier for a lot of awesome stuff, and RDS is no exception - you get to use 750 hours (31 days) a month of db. The Amazon RDS, CloudWatch, AWS Trusted Advisor and other AWS console dashboards provide an at-a-glance view of the state of your AWS environment.
RDS Custom lets you access and customize your database server host and operating system, for example, by applying special patches and changing the database software settings to Amazon Web Services (AWS) provides a collection of tools for building applications in the cloud.
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud.
Download and Unzip Sample Database Dump file: Click here to download Sample Database and extract using winrar for unzip operation. Load the sample database using pgAdmin tool Public | store | table | postgres | permanent | 8192 bytes | Public | staff | table | postgres | permanent | 16 kB |
Public | rental | table | postgres | permanent | 1232 kB | Public | payment | table | postgres | permanent | 896 kB | Public | language | table | postgres | permanent | 8192 bytes | Public | inventory | table | postgres | permanent | 232 kB | Public | film_category | table | postgres | permanent | 72 kB | Public | film_actor | table | postgres | permanent | 272 kB | Public | film | table | postgres | permanent | 464 kB | Public | customer | table | postgres | permanent | 96 kB | Public | country | table | postgres | permanent | 8192 bytes | Public | city | table | postgres | permanent | 64 kB | Public | category | table | postgres | permanent | 8192 bytes | Public | address | table | postgres | permanent | 88 kB | Public | actor | table | postgres | permanent | 40 kB | Schema | Name | Type | Owner | Persistence | Size | Description You are connected to database "dvdrental" as user "postgres" via socket in "/var/run/postgresql" at port "5432". You are now connected to database "dvdrental" as user "postgres". Validate Imported Data: Login to psql and connect to DB dvdrental using \c connection option, You can list tables from \dt+ u01]# su - postgres Pg_restore: creating FK CONSTRAINT "public.store store_manager_staff_id_fkey" Pg_restore: creating FK CONSTRAINT "public.store store_address_id_fkey" Pg_restore: creating FK CONSTRAINT "public.staff staff_address_id_fkey" Pg_restore: creating FK CONSTRAINT "public.rental rental_staff_id_key" Pg_restore: creating FK CONSTRAINT "public.rental rental_inventory_id_fkey" Pg_restore: creating FK CONSTRAINT "public.rental rental_customer_id_fkey" Pg_restore: creating FK CONSTRAINT "public.payment payment_staff_id_fkey" Pg_restore: creating FK CONSTRAINT "public.payment payment_rental_id_fkey" Pg_restore: creating FK CONSTRAINT "public.payment payment_customer_id_fkey" Pg_restore: creating FK CONSTRAINT "public.inventory inventory_film_id_fkey"
Pg_restore: creating FK CONSTRAINT "public.city fk_city" Pg_restore: creating FUNCTION "public.get_customer_balance(integer, timestamp without time zone)" Pg_restore: creating FUNCTION "public.film_not_in_stock(integer, integer)" Pg_restore: creating FUNCTION "public.film_in_stock(integer, integer)" Pg_restore: creating FUNCTION "public._group_concat(text, text)" Pg_restore: creating DOMAIN "public.year" Pg_restore: creating TYPE "public.mpaa_rating" Pg_restore: connecting to database for restore bash-4.2$ pg_restore -dbname=dvdrental -verbose dvdrental.tar