werasources.blogg.se

Loading mirror speeds from cached hostfileĮxcluding Packages from CentOS-5 - Extrasĩ5 packages excluded due to repository priority protections Loaded plugins: fastestmirror, priorities They are alternative versions, and you will need others. You don't want to install both package I mentioned. type \l for the list command that list current database instances on this cluster postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -+ - + - + -+ - postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.If you want to reinstall then remove all you have installed, but given the "foreign" version it may not have been installed by the package manager, which would make things more difficult. We can check configs and whatnot from /var/lib/pgsql/10/data Now we can verify the install - copied from terminal - init the cluster ~]# /usr/pgsql-10/bin/postgresql-10-setup initdb Initializing database … OK - start the service ~]# systemctl start rvice - switch to postgres user ~]# su - postgres - enter psql interactive terminal -bash-4.2$ psql psql (10.4) Type “help” for help. # /usr/pgsql-10/bin/postgresql-10-setup initdb

Use this command to init the cluster in its default location on the system disk. The result of the above command should look something like this ^^^ 4.