*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.kla...@aklaver.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.kla...@aklaver.com > > <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
