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

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. <[email protected]> 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 <[email protected]> wrote:




Sent from Yahoo Mail for iPhone


On Sunday, July 28, 2019, 9:58 PM, Amit S. <[email protected]> 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.

Reference : https://www.postgresql.org/docs/8.0/backup.html#BACKUP-DUMP-ALL
On Sun, Jul 28, 2019 at 7:02 PM Karen Goh <[email protected]> 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. <[email protected]> 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 <[email protected]> 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