0LcECEqP

1$ psql --host=minhainstancia.rds.amazonaws.com -d postgres -U admin
2Type "help" for help.
3postgres=> CREATE USER meuusuario WITH PASSWORD 'a';
4CREATE USER
5postgres=>
6postgres=> CREATE DATABASE meudatabase WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
7CREATE DATABASE
8postgres=> ALTER DATABASE meudatabase OWNER TO admin;
9ALTER DATABASE
10postgres=> \connect meudatabase
11You are now connected to database "meudatabase" as user "admin".
12meudatabase=>
13meudatabase=> CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA public;
14CREATE EXTENSION
15meudatabase=> CREATE TABLE minhatabela (
16meudatabase(>     order_id bigint NOT NULL,
17meudatabase(>     transmission_record hstore
18meudatabase(> );
19CREATE TABLE
20meudatabase=>
21meudatabase=> ALTER TABLE minhatabela OWNER TO meuusuario;
22ALTER TABLE
23meudatabase=>
24meudatabase=> REVOKE ALL ON SCHEMA public FROM meuusuario;
25WARNING:  no privileges could be revoked for "public"
26REVOKE
27meudatabase=> GRANT ALL ON SCHEMA public TO meuusuario;
28WARNING:  no privileges were granted for "public"
29GRANT
30meudatabase=> \q
31
32$ export PGPASSWORD="a"
33$ psql --host=minhainstancia.rds.amazonaws.com -d meudatabase -U meuusuario
34psql: FATAL:  password authentication failed for user "meuusuario"
35FATAL:  password authentication failed for user "meuusuario"
36$