PostgreSQL 14.x, 15.x (version 15.5 is included in the setup) Note that Veeam Backup & Replication does not support PostgreSQL installations on cloud database services (for example, Amazon Relational Database Service (RDS).
Fair enough. I’ll stick with 15.5 then.
Thank you for the very quick reply.
@MarkBoothman - your link is missing an “f” at the end I believe
@david.morgan - yes...migrating is pretty straightfoward as I migrated one of my VBR servers to PGSQL a few mos ago. Followed the User Guide steps. Verify all is good at the end and you should be all set.
Best!
@coolsport00 Thanks for spotting Shane …. I’m blaming old age on that one. Fixed it now :)
I understand that for sure!
I have installed v16 for Postgres in a CentOS 8 VM without issue and moved a database to it. It is running fine and no problems. As long as the permissions are there everything will work.
I have installed v16 for Postgres in a CentOS 8 VM without issue and moved a database to it. It is running fine and no problems. As long as the permissions are there everything will work.
Agreed, but “it works” is not “it’s supported”…. So, I would stay with 15.5 or lower to be supported.
I have installed v16 for Postgres in a CentOS 8 VM without issue and moved a database to it. It is running fine and no problems. As long as the permissions are there everything will work.
Agreed, but “it works” is not “it’s supported”…. So, I would stay with 15.5 or lower to be supported.
Yes, I agree - I never said it was supported I just wanted to let the OP know it does work. It is always best to stick to the “supported” release but this in my lab, so testing is fine with me on releases.
Thanks for the replies folks.
Run into a bit of a snag - I’ve created a user in Pgadmin but when I try to migrate the database I get
“no Pg_hba.conf entry for host “XXX”, User “YYY”, database “ZZZ”, no encryption
I haven’t tried to create a database as I thought the restore / migrate process created one...and yet is seems to be pointing to one…
Any ideas what I’ve missed, please?
Thank you.
Thanks for the replies folks.
Run into a bit of a snag - I’ve created a user in Pgadmin but when I try to migrate the database I get
“no Pg_hba.conf entry for host “XXX”, User “YYY”, database “ZZZ”, no encryption
I haven’t tried to create a database as I thought the restore / migrate process created one...and yet is seems to be pointing to one…
Any ideas what I’ve missed, please?
Thank you.
Does the user have the right permissions? Is this on the same Postgres install as the VBR server or a separate server? If so, is the server Windows or Linux that Postgres is installed on? If Linux there are some extra things you need to install to get it working.
Same host, which is a Windows box. I’ve used an account that has the rights to create new databases, etc but I didn’t realise I needed to restart the PG service.
Having done that I now get:
Which is a different error...so progress from a certain point of view….
In the install window what port are you using? The default one that shows there is sometimes different than what Postgres service is listening on.
Run this at command prompt to look for the port - netstat -abno
If you prefer a text file just add - > c:\temp\netstat.txt on the end of that command.
I’ve used the default port, and having run that command it says it’s listening
TCP 0.0.0.0:5432 0.0.0.0:0 Listening
In the pg_hba.conf file I can see this entry under IPv4:
host all all 127.0.0.1/32 scram-sha-256
The error looks as if it’s trying to connect to an IPv6 address, but commenting that out in the pg_hba.conf file doesn’t fix the problem.
Should I raise a support ticket?
Thanks for the replies.
David.
Okay, I had to amend the pga_hba.conf file to accept connections from ‘all’ rather than 127.0.0.1/32
Thanks for the pointers, folks.
I have installed v16 for Postgres in a CentOS 8 VM without issue and moved a database to it. It is running fine and no problems. As long as the permissions are there everything will work.
Same reason I would like to test with v16 also on Windows!
Fair enough. I’ll stick with 15.5 then.
Thank you for the very quick reply.
Absolutely! It is always wise to stick with the supported version...
Okay, I had to amend the pga_hba.conf file to accept connections from ‘all’ rather than 127.0.0.1/32
Thanks for the pointers, folks.
Just to add more information to this text as images are easier to understand!