Re: pgsql in a virtual environment

2014-05-16 11:56 GMT-03:00 Graeme Gemmill <graeme@gemmill.name>:
> $ ./pg_ctl start -D /mnt/post/pgsql/data &
> [1] 3692
> [postgres@localhost bin]$ pg_ctl: could not open PID file
> "/mnt/post/pgsql/data/postmaster.pid": Protocol error
>
> [1]+  Exit 1                  ./pg_ctl start -D /mnt/post/pgsql/data
> Is there any advice on running postgresql in a virtual machine connecting to
> host data?

Did you check your logs to see if there was any information which
would point to the problem?

Looks like a libpq - backend server mismatch.

--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services