[GENERAL] After configuring remote access,server can't be started

My postgresql 9.4 is installed in centos 6.7,and I have followed this: http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/ 1,cd /var/libpgsql/9.4/data 2,cp postgresql.conf.sample postgresql.conf 3,sudo vi postgresql.conf and add two lines,and save it: > *listen_addresses =

[GENERAL] remote connection error:could not connect to server: Connection refused

My postgresql 9.4 is installed in centos 6.7,and I have followed this: http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/ 1,cd /usr/pgsql-9.4/share/ 2,cp postgresql.conf.sample postgresql.conf 3,sudo vi postgresql.conf and add two lines,and save it: > *listen_addresses =

Re: [GENERAL]

--create --exit-on-error --dbname=icare icare-test.tar On Fri, Nov 13, 2015 at 10:52 PM, Giuseppe Sacco < giuse...@eppesuigoccas.homedns.org> wrote: > Hello, > > Il giorno ven, 13/11/2015 alle 13.38 +0800, Alex Luya ha scritto: > > Hello, > >I created a new da

[GENERAL] pg_restore tells schema “test” already exists but it isn't actually

When restoring a dump like this: pg_restore --clean --create --exit-on-error --dbname=test test.tar these error messages got printed out: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 21; 2615 80924 SCHEMA test test pg_restore:

[GENERAL]

Hello, I created a new database by create database icare; then quit off psql and run: pg_restore --clean --create --exit-on-error --dbname=icare icare-test.tar it complains: pg_restore: [archiver (db)] Error while PROCESSING TOC: