From: | "Amit S(dot)" <comeonamit(at)gmail(dot)com> |
---|---|
To: | Karen Goh <karenworld(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: How do I upgrade psql from version 7 to be 10 in Windows 10? |
Date: | 2019-07-28 13:58:26 |
Message-ID: | CAC-OOAv83QbODz+hQqxQeTbXGdY7Q6CLwwL_31NKVy4oM++8vQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
Reference : https://www.postgresql.org/docs/8.0/backup.html#BACKUP-DUMP-ALL
On Sun, Jul 28, 2019 at 7:02 PM Karen Goh <karenworld(at)yahoo(dot)com> wrote:
> What error? I need help to upgrade my psql to version 10.
>
>
>
>
> Sent from Yahoo Mail for iPhone
> <https://overview.mail.yahoo.com/?.src=iOS>
>
> On Sunday, July 28, 2019, 7:57 PM, Amit S. <comeonamit(at)gmail(dot)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(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Karen Goh | 2019-07-29 00:26:52 | Re: How do I upgrade psql from version 7 to be 10 in Windows 10? |
Previous Message | Karen Goh | 2019-07-28 13:32:24 | Re: How do I upgrade psql from version 7 to be 10 in Windows 10? |