Re: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!! - Mailing list pgsql-general

Hi Alban

Think we are making progress..

I'll need to do some research to understand how to find the event log, but
to answer your other points:

1) Glad to see you think the database started up correctly. I also noted
this problem about adminpack, and spent ages trying to find out what it was
and why it was not now installing correctly, but so far I have drawn a
blank. It interrupted the installation with a pop-up error message, although
it did allow me to continue. That was why I thought it was a program bug,
and tried to report it!
2) Yes, I did stop the Postgres before moving my data. I moved my data to
\data_old, then did the uninstall, re-installed it, stopped the program and
moved the data from \data_old back to \data and re-started Postgres. I also
checked that my registry settings for Postgres were pointing to the correct
data folder on the D: drive (which is why the install may know about it),
which is just a separate partition on my PC. Before I had any of these
problems, Postgres was able to successfully read and write to this location.
I was using Navicat to create a few basic tables, and did manage to log into
pgAdmin.
3) The log file I have attached is from the last re-install. Every time I
have uninstalled and re-installed since my first successful attempt has
produced the same (unsuccessful) result, so I think any of these logs will
show the same issues.
4) The Postgres help files seem to suggest that during an uninstall, the
/data folder will not be deleted, which seems quite sensible, as you say!
Only thing is, the system requires it to be empty during an install, as folk
are expected to either install Postgres for the first time, or perform an
upgrade which uses a different 9.x folder, and not have to reinstall the
same version. This is why I have to shift my data out of the way to
/data_old and shift it back. Assuming I can do this without using
dump/restore (another question).
5) I typed netstat -an, and found port 5432 was shown as:
  Local Address: [::]:5432, Foreign Address: [::]:0, State: LISTENING

I don't think I chose this port, I think the install defaulted to it. I
don't know if this is the right one I should choose. According to Wikipedia,
this is the default port for Postgres on TCP/UDP, although my system does
not seem to be listening on UDP, but I think just listening on TCP is
probably fine.
6) This question about connecting -I think- could be what the problem is. To
connect, I start pgAdmin and double-click on Server
groups|Servers|myLocalHost (localhost:5432) which has a red 'X' on it
(doesn't look good) to which I get a popup 'Error connecting to the server:
FATAL: password authentication failed for user "SDB"'. You mention the
pg_hba.conf file -but since I am asked to enter a new password during
installation, this is reset every time I try to do a reinstall? I am
thinking that this is not occurring, and I have entered to many wrong
passwords. For security, it would make sense that you can't reset it just by
performing a reinstall. Could you elaborate on how to get back in if I have
locked myself out please, as I think this could..be it?

Many thanks again
  Stephen

-----Original Message-----
From: Alban Hertroys [mailto:haramrae@gmail.com]
Sent: 31 July 2013 14:16
To: Stephen Brearley
Cc: pgsql-general@postgresql.org; 'Adrian Klaver'
Subject: Re: [GENERAL] Postgres 9.2.4 for Windows (Vista) Dell Vostro 400,
re-installation failure PLEASE CAN SOMEONE HELP!!

On Jul 31, 2013, at 14:07, "Stephen Brearley" <mail@stephenbrearley.name>
wrote:

> Hi Alban
>
> Much thanks for getting back to me!
>
> The event file gets written to (as attached):
> C:\Users\SDB\AppData\Local\Temp

That's the installation log, not the postgres log.
I suspect the postgres log is either in the Windows Event Log (available
from the Control Panel, perhaps under Administrative Tools or something
similar) or in a file somewhere in the Postgres installation directory, most
likely in a directory named log. I don't know how EnterpriseDB sets things
up though, certainly not in Windows.

Nevertheless, from the installation log it can be seen that initdb was run
and that after that the database started up successfully.

It also shows that some module named "adminpack" failed to install. I have
no idea what that is though, I don't have it on my UNIX system.
See:

Script output:
 Installing the adminpack module in the postgres database...
    Executing 'C:\Users\SDB\AppData\Local\Temp\rad5E7BA.bat'...
    Couldn't find the output file...
Failed to install the 'adminpack' module in the 'postgres' database
loadmodules.vbs ran to completion

Script stderr:
 Program ended with an error exit code

Error running cscript //NoLogo "C:\Program
Files\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****"
"C:\Program Files\PostgreSQL\9.2"
"D:\_SDB\Database\RDBMS\PostgreSQL\9.2\data" 5432 : Program ended with an
error exit code

So, whatever causes your issue is most likely due to something that happened
after the install.

> I copied the contents of the /data directory to the D: drive, then
> changed the folder reference in the Registry. However, after this I
> was able to

Did you first stop the database? If not, chances are you didn't get a
consistent copy, because the database was working on those files while you
were copying them.
Oh, and I assume your D: drive isn't some kind of network drive or
something, but an actual disk with NTFS on it?

> create tables in Navicat without any problems, until I tried to use
> pgAdmin when it required my password, which I had forgotten. Then I
> tried to reinstall, and started having these problems..

So all the above is from before you uninstalled/reinstalled? Or is that log
file you attached from the reinstall?
In that case, it seems to have known about your data-directory on D: during
the install, looking at this snippet:

Loading additional SQL modules...
Executing cscript //NoLogo "C:\Program
Files\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****"
"C:\Program Files\PostgreSQL\9.2"
"D:\_SDB\Database\RDBMS\PostgreSQL\9.2\data" 5432 Script exit code: 2

It exits with code 2, which indicates an error. Perhaps the logs (see
earlier) say why.

> I'm being recommended to try running pg_dump by Thomas Kellerer, then
> remove all my data folders and a reinstall. I get the feeling it is
> not moving my data to the D: drive that has caused the problem, but
> that the Uninstall has not cleaned this out correctly, as I moved my
> data to D:/../data_old to enable Postgres to reinstall and used the
> installation Wizard to point to my data location, but still get
> installation errors and a connection problem, despite using the 'correct'
password.

I doubt that the uninstaller would remove your data directory, because then
you would lose your data. You don't want that, it's generally better to
leave decisions like that up to the administrator (you). That data is more
often than not quite valuable ;)

> When I start pgAdmin, TaskManager shows that Postgres is running, -so
> I don't think I have an unrecoverable database snapshot?

That Postgres appears to be running is encouraging.

Something worth verifying; open a command prompt and type netstat -an and
look whether the port you configured Postgres to run on is being listened
on.

If it is, then your issue is just a connection issue. Perhaps you could
elaborate on what you're doing to connect and what error you receive?

It's possible that you locked yourself out through the pg_hba.conf file or
that you need to reset the password for the postgres user. But we don't know
that yet...


> -----Original Message-----
> From: Alban Hertroys [mailto:haramrae@gmail.com]
> Sent: 31 July 2013 11:48
> To: Stephen Brearley
> Cc: 'Adrian Klaver'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Postgres 9.2.4 for Windows (Vista) Dell Vostro
> 400, re-installation failure PLEASE CAN SOMEONE HELP!!
>
> On Jul 31, 2013, at 12:07, "Stephen Brearley"
> <mail@stephenbrearley.name>
> wrote:
>
>> Both the install and uninstall should work flawlessly. The only thing
>> I can see is that I have installed the program once before, and I
>> have put my data on my d: drive to separate it from the program in
>> case of software problems, but I got Postgresql to correctly find my data
before..
>
>
> If Postgres is having any issues starting up, details should be in the
> log file. I don't know where that file gets written on a Windows
> system though, perhaps it ends up in the Windows Event log?
>
> What procedure did you follow to move your data to the D-drive? That
> seems a likely cause of trouble, especially if the database was
> running while you did that - you may be looking at an unrecoverable
> database snapshot if you didn't take precautions, in which case the
> database would refuse to start up.
>
> Alban Hertroys
> --
> If you can't see the forest for the trees, cut the trees and you'll
> find there is no forest.
>
> <install-postgresql.log>

Alban Hertroys
--
If you can't see the forest for the trees, cut the trees and you'll find
there is no forest.