| From: | Chris Charley <charleyc2718(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Should I reinstall over current installation? |
| Date: | 2020-02-03 20:20:50 |
| Message-ID: | CAN4LocCC6Y=LvYYFO_5670ydtXxEkkkB2zdW5Nusa8LbGyjH7A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 line 8.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-02-03 20:26:48 | Re: Should I reinstall over current installation? |
| Previous Message | Ron | 2020-02-03 19:35:01 | Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI |