Skip to main content

Posts

Showing posts with the label PostgreSQL

How to install PostgreSQL 10 on Amazon EC2

Step 1. Add PostgreSQL 10 repository amazon-linux-extras install postgresql10 epel -y Step 2. Install PostgreSQL 10 yum install -y postgresql-server postgresql-devel Step 3. Initializing database /usr/bin/postgresql-setup --initdb * Initializing database in '/var/lib/pgsql/data' * Initialized, logs are in /var/lib/pgsql/initdb_postgresql.log Step 4. Start the services of PostgreSQL and start on startup. systemctl start postgresql systemctl enable postgresql Step 5. Login into Database su - postgres You can get into Postgres console by typing psql To get the help use the \h command.