Postgres Pro
Downloads
Home   >   mailing lists

Thread: How do I upgrade psql from version 7 to be 10 in Windows 10?

How do I upgrade psql from version 7 to be 10 in Windows 10?

From
Karen Goh
Date:
Greetings,

I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which
Ihad downloaded this year.
 

Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission
toAll in Windows 10.
 

Now, I tried to follow this article :
https://www.arencambre.com/blog/2014/12/24/postgress-pg_upgrade-on-windows-the-documentation-misses-a-lot/But, I am
gettingdenial of access using my postgres user password.
 

And it seems that it is easier to operate psql using linux.  But, I am new to Linux, just like PostgreSQL.

So, I hope someone can really come and help me out in terms of upgrading my PSQL and then secondly share with me
articlehow to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.
 

Thanks

Karen

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
"Amit S."
Date:
At what step are you getting the error? Can you share the exact error message and if possible the logs from ::

C:\Program Files\PostgreSQL\1o\data\log

On Sun, Jul 28, 2019 at 9:30 AM Karen Goh <karenworld@yahoo.com> wrote:
Greetings,

I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which I had downloaded this year.

Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission to All in Windows 10.

Now, I tried to follow this article : https://www.arencambre.com/blog/2014/12/24/postgress-pg_upgrade-on-windows-the-documentation-misses-a-lot/ But, I am getting denial of access using my postgres user password.

And it seems that it is easier to operate psql using linux.  But, I am new to Linux, just like PostgreSQL.

So, I hope someone can really come and help me out in terms of upgrading my PSQL and then secondly share with me article how to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.

Thanks

Karen





--

Amit Sharma

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
Karen Goh
Date:
What error? I need help to upgrade my psql to version 10.




Sent from Yahoo Mail for iPhone

On Sunday, July 28, 2019, 7:57 PM, Amit S. <comeonamit@gmail.com> wrote:

At what step are you getting the error? Can you share the exact error message and if possible the logs from ::

C:\Program Files\PostgreSQL\1o\data\log

On Sun, Jul 28, 2019 at 9:30 AM Karen Goh <karenworld@yahoo.com> wrote:
Greetings,

I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which I had downloaded this year.

Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission to All in Windows 10.

Now, I tried to follow this article : https://www.arencambre.com/blog/2014/12/24/postgress-pg_upgrade-on-windows-the-documentation-misses-a-lot/ But, I am getting denial of access using my postgres user password.

And it seems that it is easier to operate psql using linux.  But, I am new to Linux, just like PostgreSQL.

So, I hope someone can really come and help me out in terms of upgrading my PSQL and then secondly share with me article how to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.

Thanks

Karen





--

Amit Sharma

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
"Amit S."
Date:
YOu memtioned  
"But, I am getting denial of access using my postgres user password."

I havent read the article and not sure about 7.6 but I am sure its not going to be a straight forward update. 

If you still have the 7.4 server, try doing to pg_dump in plain SQL and then feed that SQL to 10. 


On Sun, Jul 28, 2019 at 7:02 PM Karen Goh <karenworld@yahoo.com> wrote:
What error? I need help to upgrade my psql to version 10.




Sent from Yahoo Mail for iPhone

On Sunday, July 28, 2019, 7:57 PM, Amit S. <comeonamit@gmail.com> wrote:

At what step are you getting the error? Can you share the exact error message and if possible the logs from ::

C:\Program Files\PostgreSQL\1o\data\log

On Sun, Jul 28, 2019 at 9:30 AM Karen Goh <karenworld@yahoo.com> wrote:
Greetings,

I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which I had downloaded this year.

Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission to All in Windows 10.

Now, I tried to follow this article : https://www.arencambre.com/blog/2014/12/24/postgress-pg_upgrade-on-windows-the-documentation-misses-a-lot/ But, I am getting denial of access using my postgres user password.

And it seems that it is easier to operate psql using linux.  But, I am new to Linux, just like PostgreSQL.

So, I hope someone can really come and help me out in terms of upgrading my PSQL and then secondly share with me article how to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.

Thanks

Karen





--

Amit Sharma


--

Amit Sharma

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
Karen Goh
Date:

no. I think you have problem understanding my requirements. I need to know how to upgrade my psql 7 to 10! I need to solve this for good



Sent from Yahoo Mail for iPhone

On Sunday, July 28, 2019, 10:57 PM, Amit S. <comeonamit@gmail.com> wrote:

Ok so multiple things here, database username and password are different than the OS uername and password. 

Did you modify any permissions on the data folder?

I think I have said it 2 times I have changed permissions to allow ALL!

Where are you located? Would it be possible to have a screen share tomorrow and I will at least solve your connection problem. I have not worked on 7.4 so I will not be able to find a soltuion to migrate without actually getting to know the file format in which you have the old database.

On Sun, Jul 28, 2019 at 8:20 PM Karen Goh <karenworld@yahoo.com> wrote:



Sent from Yahoo Mail for iPhone

On Sunday, July 28, 2019, 9:58 PM, Amit S. <comeonamit@gmail.com> wrote:

YOu memtioned  
"But, I am getting denial of access using my postgres user password."

Yes. But that’s not an error. It doesn’t give me error. That password is not recognised. It is the same password I use for that username in psql. So, by right, I should gain access right? I mean I have stated in my email that I have granted all access at the control in Windows 10. 

I havent read the article and not sure about 7.6 but I am sure its not going to be a straight forward update. 

If you still have the 7.4 server, try doing to pg_dump in plain SQL and then feed that SQL to 10. 


I don’t think I have 7.4 server.

PgAdmin 4 indicates my server is 10.



On Sun, Jul 28, 2019 at 7:02 PM Karen Goh <karenworld@yahoo.com> wrote:
What error? I need help to upgrade my psql to version 10.




Sent from Yahoo Mail for iPhone

On Sunday, July 28, 2019, 7:57 PM, Amit S. <comeonamit@gmail.com> wrote:

At what step are you getting the error? Can you share the exact error message and if possible the logs from ::

C:\Program Files\PostgreSQL\1o\data\log

On Sun, Jul 28, 2019 at 9:30 AM Karen Goh <karenworld@yahoo.com> wrote:
Greetings,

I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which I had downloaded this year.

Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission to All in Windows 10.

Now, I tried to follow this article : https://www.arencambre.com/blog/2014/12/24/postgress-pg_upgrade-on-windows-the-documentation-misses-a-lot/ But, I am getting denial of access using my postgres user password.

And it seems that it is easier to operate psql using linux.  But, I am new to Linux, just like PostgreSQL.

So, I hope someone can really come and help me out in terms of upgrading my PSQL and then secondly share with me article how to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.

Thanks

Karen





--

Amit Sharma


--

Amit Sharma


--

Amit Sharma

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
Keith
Date:


On Sun, Jul 28, 2019 at 8:27 PM Karen Goh <karenworld@yahoo.com> wrote:

no. I think you have problem understanding my requirements. I need to know how to upgrade my psql 7 to 10! I need to solve this for good




You must dump and restore your database to upgrade from a version that old. pgupgrade will not work with a version jump that drastic.

Use pg_dumpall -g to dump out the global objects (roles, tablespaces, etc). And use pg_dump to dump out the individual databases. And be sure to use the pgdump from version 10 to create the dump files, not the old version.
Then you can feed the file created by pg_dumpall into the new database using psql -f since it's a plain sql file.
Then use pg_restore to restore the database dump(s).

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
Karen Goh
Date:



Sent from Yahoo Mail for iPhone

On Monday, July 29, 2019, 8:33 AM, Keith <keith@keithf4.com> wrote:



On Sun, Jul 28, 2019 at 8:27 PM Karen Goh <karenworld@yahoo.com> wrote:

no. I think you have problem understanding my requirements. I need to know how to upgrade my psql 7 to 10! I need to solve this for good




You must dump and restore your database to upgrade from a version that old. pgupgrade will not work with a version jump that drastic. 

But, my database is residing in version 10, not 7. So, I really need to just upgrade the psql.exe to version 10. Actually I don’t know why psql is version 7 and the server for my database is in 10.

Use pg_dumpall -g to dump out the global objects (roles, tablespaces, etc). And use pg_dump to dump out the individual databases. And be sure to use the pgdump from version 10 to create the dump files, not the old version.
Then you can feed the file created by pg_dumpall into the new database using psql -f since it's a plain sql file.
Then use pg_restore to restore the database dump(s).

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
"David G. Johnston"
Date:
On Saturday, July 27, 2019, Karen Goh <karenworld@yahoo.com> wrote:
I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which I had downloaded this year.

Start from scratch on a clean system and consider your existing database lost.  If that is not acceptable then probably should just find someone locally to do this for you.  Your reported setup of seeing a 7.* psql application on Windows 10 is so far off track that trying to figure out your unique situation over email seems unlikely to attract free help from qualified people.
 
Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission to All in Windows 10.

You should understand that as used on these list “psql 10” typically refers to the server.  Since you seem to mean just the command line program you need to be a bit more verbose here.
 
 and then secondly share with me article how to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.

People have written many beginner level books on this kind of thing.  You should read a number of them.

Frankly I’d suggest you use VirtualBox to run Linux inside Windows.  Spending some time learning that will go a long way if you plan on picking up experience with Linux starting from a position of primary Windows usage.

David J.

Re: How do I upgrade psql from version 7 to be 10 in Windows 10?

From
Karen Goh
Date:





On Monday, July 29, 2019, 9:53:42 AM GMT+8, David G. Johnston <david.g.johnston@gmail.com> wrote:


On Saturday, July 27, 2019, Karen Goh <karenworld@yahoo.com> wrote:

I was wrestling with my database migration till I found out that I actually had a 7.6 PSQL version instead of 10 which I had downloaded this year.


Start from scratch on a clean system and consider your existing database lost. If that is not acceptable then probably should just find someone locally to do this for you. Your reported setup of seeing a 7.* psql application on Windows 10 is so far off track that trying to figure out your unique situation over email seems unlikely to attract free help from qualified people.

I can't really start from scratch as I need the database which is already in my version 10 pgAdmin4 cos I painstakingly built them up and because I am not familiar with PostgreSQL system I don't want to throw them away and start afresh cos I have million things to tackle including a serious case of moving to VPS etc or Cloud and I need to be sure my next webhost works.

I don't have anybody to turn to. Everything I learnt is from forum, online free courses etc. so that is the reason I asked for help here.



Now, I have problem in upgrading PSQL to 10 even though I had done all the ncessary steps like setting the permission to All in Windows 10.


You should understand that as used on these list “psql 10” typically refers to the server. Since you seem to mean just the command line program you need to be a bit more verbose here.


and then secondly share with me article how to use Linux from installation as a dual boot drive in my laptop and using Linux with Postgresql.


People have written many beginner level books on this kind of thing. You should read a number of them.

Frankly I’d suggest you use VirtualBox to run Linux inside Windows. Spending some time learning that will go a long way if you plan on picking up experience with Linux starting from a position of primary Windows usage.

David J.