Re: file system level backup

On 01/04/2014 01:20 PM, zach cruise wrote:
>
> Questions:
>
> 1) Both servers are x64?
>
> > yes
>
> 2) What installation files(Graphical installer, source,etc)?
>
> > postgresql-9.3.0-1-windows-x64 from enterprisedb.com
> <http://enterprisedb.com>
>
> 3) Does the data directory have the config files?
>
> > yes
>
> however, postgresql b won't start ("not listening")?
>
> 4) How are you starting?
>
> > pgadmin -> start server
>
> 5) What is the exact error message and where are you seeing it?
>
> > "server not listening on port 5432" in cmd ('netstat -ab | find
> "5432"' also returns empty)

Have you checked what port is set up in postgresql.conf?

I am not that familiar with Windows and pgAdmin so I will resort to the
docs:

Does any of the below apply?

http://www.pgadmin.org/docs/1.8/connect.html

"If pgAdmin is running on a Windows machine, it can control the
postmaster service if you have enough access rights. Enter the name of
the service. In case of a remote server, it must be prepended by the
machine name (e.g. PSE1\pgsql-8.0). pgAdmin will automatically discover
services running on your local machine. "

>
> so i restored postgresql b's old /data/, but it still won't start?!
>
> 6) So there was an existing Postgres instance at b?
>
> > yes. two installations - a and b.

I am still not understanding. You have a 2008 server at a and one at b.
You copied the Postgres data files from 2008 server a to 2008 server b.
This did not work, so you say you restored the data directory on server
b from an old copy of the data directory at b.

So where did that old copy come from?

>
> 7) What version was it?
>
> > both are 9.3.0-1 from the same installation file (above).
>
> fyi, pg_bouncer process was running even after the server shutdown when
> i did the copy (since size is not an issue, i could copy the entire
> /postgresql/?).
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com