![]() ![]() Restoring global objects in the new cluster okĪdding support functions to new cluster ok Setting frozenxid and minmxid counters in new cluster ok Setting next multixact ID and offset for new cluster ok Setting next transaction ID and epoch for new cluster okĭeleting files from new pg_multixact/offsets okĬopying old pg_multixact/offsets to new server okĭeleting files from new pg_multixact/members okĬopying old pg_multixact/members to new server ok If pg_upgrade fails after this point, you must re-initdb the pg_upgradeįirst we have to make sure both database servers are not running when we do the upgrade:Ĭhecking for reg * system OID user data types okĬhecking for contrib/isn with bigint-passing mismatch okĬhecking for invalid "line " user columns okĬhecking for presence of required libraries ok This means there will be no password on your development database, so you can skip the password field in database.yml or leave it * completely empty. Interesting to note, but if you use PostgreSQL with Rails. You can find that out easily with whoami. For one, the user won't be olivierlacan but whatever your system user is. You can now start the database server using: postgres -D /usr/local/var/postgres or pg_ctl -D /usr/local/var/postgres -l logfile start ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or -auth-local and -auth-host, the next time you run initdb. ok loading PL/pgSQL server-side language. ok setting privileges on built-in objects. posixĬreating template1 database in /usr/local/var/postgres/base/1. Selecting dynamic shared memory implementation. The default text search configuration will be set to "english ".Ĭreating directory /usr/local/var/postgres. ![]() ![]() The default database encoding has accordingly been set to "UTF8 ". The database cluster will be initialized with locale "en_US.UTF-8 ". This user must also own the server process. The files belonging to this database system will be owned by user "olivierlacan ". ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |