Mudanças entre as edições de "PostgreSQL"
De MochilaWiki
Ir para navegaçãoIr para pesquisar| Linha 6: | Linha 6: | ||
postgres=# alter user postgres with encrypted password '123456'; | postgres=# alter user postgres with encrypted password '123456'; | ||
postgres=# \q | postgres=# \q | ||
| + | |||
| + | == instalando no openSUSE == | ||
| + | zypper install -y postgresql postgresql-server | ||
| + | rcpostgresql start | ||
| + | su - postgres | ||
| + | psql | ||
| + | postgres=# ALTER USER postgres WITH PASSWORD 'postgres'; | ||
| + | postgres=# \q | ||
| + | rcpostgresql start | ||
| + | sed -i '82s/ident/trustg' /var/lib/pgsql/data/pg_hba.conf | ||
Edição das 21h22min de 7 de janeiro de 2015
pg_dump -C -h IP_DO_SERVIDOR -U USUARIO_DO_DB DB_NAME > bkp.sql
alterando a senha
# su - postgres $ psql postgres postgres=# alter user postgres with encrypted password '123456'; postgres=# \q
instalando no openSUSE
zypper install -y postgresql postgresql-server rcpostgresql start su - postgres psql postgres=# ALTER USER postgres WITH PASSWORD 'postgres'; postgres=# \q rcpostgresql start sed -i '82s/ident/trustg' /var/lib/pgsql/data/pg_hba.conf
