Should I reinstall over current installation?
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
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> 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
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 thedatabase.
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. Iwas
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
Import Notes
Reply to msg id not found: CAN4LocDp-mZh-ZP3enxaXj1Z+HXSG_AxW+cAjbXbp30aC7TW5Q@mail.gmail.com
*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.klaver@aklaver.com>
wrote:
Show quoted text
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
On 2/3/20 12:54 PM, Chris Charley wrote:
/What does the Windows system log show when you do this?/
I don't know where to find this log (for Windows 10)
I'm not a Windows user, what I can do is point you at:
--
Adrian Klaver
adrian.klaver@aklaver.com
Hi
The link you provided (
https://www.howtogeek.com/123646/htg-explains-what-the-windows-event-viewer-is-and-how-you-can-use-it/
)
Points me to Event Viewer but I'm kinda lost there trying to find anything
pertaining to postgreql.
On Mon, Feb 3, 2020 at 4:02 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
Show quoted text
On 2/3/20 12:54 PM, Chris Charley wrote:
/What does the Windows system log show when you do this?/
I don't know where to find this log (for Windows 10)
I'm not a Windows user, what I can do is point you at:
--
Adrian Klaver
adrian.klaver@aklaver.com
On 2/3/20 1:11 PM, Chris Charley wrote:
Hi
The link you provided
(https://www.howtogeek.com/123646/htg-explains-what-the-windows-event-viewer-is-and-how-you-can-use-it/)Points me to Event Viewer but I'm kinda lost there trying to find
anything pertaining to postgreql.
I cranked up a Windows 7 instance, which should be close enough. What I
found:
1) Open Event Viewer
2) Click on Windows Logs
3) Click on Application
4) The center section will show logs. The application name is under Source.
5) If you want to search, then Ctrl+f and enter Postgres
On Mon, Feb 3, 2020 at 4:02 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:On 2/3/20 12:54 PM, Chris Charley wrote:
/What does the Windows system log show when you do this?/
I don't know where to find this log (for Windows 10)
I'm not a Windows user, what I can do is point you at:
--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
--
Adrian Klaver
adrian.klaver@aklaver.com
I tried items you suggested (1-5), but could find no helpful info.
Thanks for your help and going the extra mile!
On Mon, Feb 3, 2020 at 4:23 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
Show quoted text
On 2/3/20 1:11 PM, Chris Charley wrote:
Hi
The link you provided
(Points me to Event Viewer but I'm kinda lost there trying to find
anything pertaining to postgreql.I cranked up a Windows 7 instance, which should be close enough. What I
found:1) Open Event Viewer
2) Click on Windows Logs
3) Click on Application
4) The center section will show logs. The application name is under Source.
5) If you want to search, then Ctrl+f and enter Postgres
On Mon, Feb 3, 2020 at 4:02 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:On 2/3/20 12:54 PM, Chris Charley wrote:
/What does the Windows system log show when you do this?/
I don't know where to find this log (for Windows 10)
I'm not a Windows user, what I can do is point you at:
--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>--
Adrian Klaver
adrian.klaver@aklaver.com
On 2/3/20 3:16 PM, Chris Charley wrote:
I tried items you suggested (1-5), but could find no helpful info.
Well in that case I would try a reinstall.
Thanks for your help and going the extra mile!
On Mon, Feb 3, 2020 at 4:23 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:On 2/3/20 1:11 PM, Chris Charley wrote:
Hi
The link you provided
Points me to Event Viewer but I'm kinda lost there trying to find
anything pertaining to postgreql.I cranked up a Windows 7 instance, which should be close enough. What I
found:1) Open Event Viewer
2) Click on Windows Logs
3) Click on Application
4) The center section will show logs. The application name is under
Source.5) If you want to search, then Ctrl+f and enter Postgres
On Mon, Feb 3, 2020 at 4:02 PM Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
<mailto:adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>> wrote:
On 2/3/20 12:54 PM, Chris Charley wrote:
> /What does the Windows system log show when you do this?/
>
> I don't know where to find this log (for Windows 10)
>I'm not a Windows user, what I can do is point you at:
--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com><mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
--
Adrian Klaver
adrian.klaver@aklaver.com
Hello Moreno
Thanks for the reply!
I ran Services and it reported postsql as Disabled.
[image: services.png]
I also ran Event Viewer and found no mention of postgresql there in errors.
Then I ran Task Manager and the services tab and it showed postgresql as
stopped.
[image: image.png]
I am considering reinstall because I couldn't find any helpful info from
these services.
Thanks again for your help.
I suspect when Windows was reinstalled, the firewall was reconfigured and
PostgreSQL wasn't allowed to access the port?
Chris
On Tue, Feb 4, 2020 at 7:40 AM Moreno Andreo <moreno.andreo@evolu-s.it>
wrote:
Show quoted text
Il 04/02/2020 00:16, Chris Charley ha scritto:
I tried items you suggested (1-5), but could find no helpful info.
Thanks for your help and going the extra mile!
Hope I'm in time to try to save you from reinstall :-)
How to check if PostgreSQL is running
---------------------------------------------------
- Run Services.msc
- In the console you should have an entry with your postgres version (I
have 9.1 and 9.5 on this host)
- Check it's automatically started and running (It's in Italian, "In
esecuzione" means "running" and "Automatico", well.... :-)))))).
- If it's not, try to start it (right click on the service and select
start)
- If you get an error, check the error messageHow to check the error message
-------------------------------------------
You have 2 choices1 - Postgres Logs)
of all, you should check PostgreSQL logs under <Postgres install
folder>\data\pg_log. Here you should find some files showing you most of
the errors you would find in Event Viewer.
Check error messages and, if still needed, post them2 - Windows Event Log)
- Enter Event Viewer
- Sort Events by date descending
- First entries should reveal why your postgres server is not running
(I captured the first error I got on this host just for example)
- On the lower pane, check what's the error message (in my case, "FATAL:
The database system is starting up").If you need further help, post the error message and we'll try to help you.
Hope this help
Moreno.-
Il 04/02/2020 21:18, Chris Charley ha scritto:
Hello Moreno
Thanks for the reply!
I ran Services and it reported postsql as Disabled.
A disabled service will never run nor leave error messages anywhere
Right click on the Postgresql service, select properties.
In the next window, choose startup type (the combo under the executable
path) and select Automatic, then click on the Start button below
Click OK and close the window.
Now something should happen. If everything goes well, You'll see
"Started" and "Automatic" in the two columns next to the service
description, and you can start your application
If there is an error message, then it should log something. See my last
mail to extract log informations and post them here
I am considering reinstall because I couldn't find any helpful info
from these services.
You got no helpful info because service does not start, andd so does not
log.... :-)
Thanks again for your help.
I suspect when Windows was reinstalled, the firewall was reconfigured
and PostgreSQL wasn't allowed to access the port?
ATM there's a service start issue to be resolved, if there's also
something about the firewall, we'll think about it later.
Moreno.-
Moreno, thank you for all your help.
Following your instructions, I was able to recover my databases. All is
good.
Chris
On Wed, Feb 5, 2020 at 6:45 AM Moreno Andreo <moreno.andreo@evolu-s.it>
wrote:
Show quoted text
Il 04/02/2020 21:18, Chris Charley ha scritto:
Hello Moreno
Thanks for the reply!
I ran Services and it reported postsql as Disabled.
A disabled service will never run nor leave error messages anywhere
Right click on the Postgresql service, select properties.
In the next window, choose startup type (the combo under the executable
path) and select Automatic, then click on the Start button below
Click OK and close the window.Now something should happen. If everything goes well, You'll see
"Started" and "Automatic" in the two columns next to the service
description, and you can start your application
If there is an error message, then it should log something. See my last
mail to extract log informations and post them hereI am considering reinstall because I couldn't find any helpful info
from these services.You got no helpful info because service does not start, andd so does not
log.... :-)Thanks again for your help.
I suspect when Windows was reinstalled, the firewall was reconfigured
and PostgreSQL wasn't allowed to access the port?ATM there's a service start issue to be resolved, if there's also
something about the firewall, we'll think about it later.Moreno.-