Author: cgr Language: text
Description: Not specified Timestamp: 2017-09-01 22:42:14 +0000
View raw paste Reply
./configure
make
su
make install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Stop service:
pg_ctl stop -D /usr/loca/pgsql/data/ > /home/postgres/logfile 2>&1 &
Start service:
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data/ >/home/postgres/logfile 2>&1 &
Connect local:
./psql -d bitacora_cliente -U postgres
Connect to BR:
/usr/local/pgsql/bin/psql -d bitacora_cliente -U postgres -h 192.1.0.181
Export:
./pg_dump -U postgres -W -h 192.1.0.181 brmclientesbd > /home/postgres/brmclientesbd.sql
Import:
psql -U USERNAME DBNAME < dbexport.pgsql
View raw paste Reply