From: | Chris Charley <charleyc2718(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Should I reinstall over current installation? |
Date: | 2020-02-03 20:54:07 |
Message-ID: | CAN4LocBYfV0g0RSy1UHe6RcPL8r-EVWVykTOFRarD-cd+FXBag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
*What does the Windows system log show when you do this?*
I don't know where to find this log (for Windows 10)
On Mon, Feb 3, 2020 at 3:47 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 2/3/20 12:44 PM, Chris Charley wrote:
> Please reply to list also.
> Ccing list.
> > Adrian
> >
> > /Does Postgres still exist on the system?
> >
> > If it does have you started the service?/
> >
> > PostgreSQL-x64-12 is list as 'stopped' in the task manger services tab.
> > When I try to 'start', it doesn't change to 'running'.
>
> What does the Windows system log show when you do this?
>
>
> >
> >
> > On Mon, Feb 3, 2020 at 3:26 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
> >
> > On 2/3/20 12:20 PM, Chris Charley wrote:
> > > I just got my Windows 10 computer in Nov 2019 and installed
> > PostgreSQL
> > > Jan this year.
> > >
> > > I had a problem with Windows update and when I contacted
> > Microsoft, they
> > > installed a fresh operating system. After that, I was unable to
> run
> > > postgres from pgAdmin 4 or from a perl program that accessed the
> > database.
> > >
> > > The message I got was:
> > >
> > > could not connect to server: Connection refused
> > (0x0000274D/10061) Is
> > > the server running on host "localhost" (127.0.0.1) and accepting
> > TCP/IP
> > > connections on port 5432? at pg_01.pl <http://pg_01.pl>
> > <http://pg_01.pl> line 8.
> > > **//___^
> >
> > Does Postgres still exist on the system?
> >
> > If it does have you started the service?
> >
> > > I was considering 2 options:
> > >
> > > !) Reinstall postgres over the current without removing the
> current
> > > postgres first.
> > > 2) uninstall the current postgres and then install postgres again.
> > >
> > > The tables I created in my database are not many and if I lose
> them
> > > doing a reinstall, I could recreate my database and the tables. I
> > was
> > > considering option (1) as I was wondering if that choice would
> > keep the
> > > database and tables I created this January.
> > >
> > > (The database and contained tables are from 'Practical SQL' by
> > Anthony
> > > DeBarros.)
> > >
> > > A second question is: When I try to edit anything in pgAdmin,
> > sometimes
> > > it won't let me edit the code. I then refresh the database in the
> > left
> > > pane and then it allows me to edit the SQL in the query pane.
> > >
> > > Thank you for any help you may provide.
> > >
> > > Chris
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-02-03 21:01:59 | Re: Should I reinstall over current installation? |
Previous Message | Adrian Klaver | 2020-02-03 20:47:05 | Re: Should I reinstall over current installation? |