![]() ![]() Remember, do not attempt to try this unless you just made a backup of your database. The major revision level is denoted by the first two digits of the postgres version. These steps are for updating Postgres on a Macintosh OSX server where the version of postgres is at the SAME major revision level as you are currently running. Reload (or restart) the Postgres server configuration and make sure others can now log in.Uncomment any access that you removed previously.After the database has been restored, edit the pg_hba.conf and.9.3), then follow the steps for updating an older version. If you have a version of Postgres that is older than 9.4 (i.e.If the version is at least 9.4, follow the instructions to update the same version of Postgres.Refer back to the version of the database that you recorded in the first step above Once you have confirmed the backup exists and have made another copy of that in a different place (just to be safe), then follow the specific instructions for updating the same version or from an older version as required.Make sure you have made a backup of the database, using the procedures in the daily backup job process.Reload (or restart) the Postgres server configuration to make sure no other user would be able to log in and disrupt the upgrade.You do this by double clicking on the row containing the IP address and unchecking it. Comment out any access that is allowed from any another IP address - and only allow access from 127.0.0.1.(optional) If you are worried that staff people might log in to Theatre Manager while the upgrade is happening, use PGAdmin (Tools->Server Configuration menu) to edit the pg_hba.conf file to restrict access and.Log everybody out of Theatre Manager, including.You will see your database name followed by a number such as (9.4.x) or (9.3.x) etc. Look at the bottom left of the 'about Theatre Manager' screen. This is in the 'About Theatre Manager' menu. Check the version of Postgres you are running.Once you have it, make sure you have done the following steps: ![]() This also indicates when to make a backup after everybody has been locked out of the database.Äownload the latest Postgres installer from the ArtsMan web site. If you have already installed the Postgres database engine on your Macintosh server and need to update it, then follow the appropriate update steps. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |