Re: Trouble Getting Database Server Started

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> I see from the Postgres archives that one can simply take a 
> copy of the installed PostgreSQL directory folder and move it 
> in place of the PostsgreSQL folder on a working system. I 
> took another computer (Computer B) and ran the same 
> installation script and tested to verify I could connect with 
> psql. Window's Task Manager showed
> 6 postgres processes: postmaster.exe, pg_ctl.exe, and 4 
> postgres.exe. (Not sure what the 4 postgres.exe are for.)

That's normal. It's one logger, one bgwriter and two stats processes.


> I don't know what caused Computer A to power down. It is in a 
> lab and someone may have inadvertently cut the power. Would 
> that corrupt the database to the point where I can't connect 
> to it or its startup mechanism be disrupted? I don't know 
> what role those 4 postgres.exe processes fill - are they part 
> of standard postgres startup? Secondly, I don't know why 
> sliding in the archived PostgreSQL folder on Computer B did not work.

It normally sholdn't. You'll need to look into your logs to see wha
thave happened. Both the files in pg_log and in the system eventlog.

//Magnus


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux