Re: How do I upgrade psql from version 7 to be 10 in Windows 10?
От | Amit S. |
---|---|
Тема | Re: How do I upgrade psql from version 7 to be 10 in Windows 10? |
Дата | |
Msg-id | CAC-OOAv83QbODz+hQqxQeTbXGdY7Q6CLwwL_31NKVy4oM++8vQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: How do I upgrade psql from version 7 to be 10 in Windows 10? (Karen Goh <karenworld@yahoo.com>) |
Список | pgsql-novice |
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 iPhoneOn 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\logOn 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
В списке pgsql-novice по дате отправления: