Re: Should I reinstall over current installation?

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.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>


--
Adrian Klaver
adrian.klaver@aklaver.com