Migrating to PostgreSQL - couple of questions....

[mvalpreda]

Working on doing a migration from SQL Express to PostgreSQL after doing a v11 to v12 upgrade and curious about a few things....

1) Are there any guides on the migration process? I see that PostgreSQL is just a next-next-next sort of install. I see the migration documents reference a 'veeam' account. I assume i need to create that user in PostgreSQL. What permissions are needed for that user? Superuser? Or something less god-like?
2) Can I uninstall all the Microsoft SQL bits after the migration?

Thanks for any input!

[HannesK]

Hello,

1) For the migration, there is a documentation in the user guide. I already asked tech writers to add permissions for Postgres also in the "required permissions" section. In general, it's the same as with SQL... if you pre-create the database, then the software only needs permissions on the database. If the setup should create the database, then permissions to create databases are needed.

2) If you don't use SQL, then SQL can be uninstalled.

Best regards,
Hannes

[mvalpreda]

I have seen that document plenty of times. I just didn't see anything on best practice for the PostgreSQL install. The link about 'required permissions' only refers to backing up PostgreSQL, not using it as a database. I'll start with create database and can login.

Thanks! I'll clean all that up after disabling the services for a little bit.

[HannesK]

the only best practice for now is running the "tuning script" in the "IMPORTANT" section (Set-VBRPSQLDatabaseServerLimits)

The database runs per default with archive_mode disabled and does not fill up the entire disk. Ff you enable archive_mode, then you need to clean up the log (same as with SQL in "full recovery" mode)