![]() Psql -U postgres -W with username and password Postgres=# alter user postgres with logout ![]() There is no password after initialization, you can directly connect su postgres or psql -U postgres ![]() You can view the startup log cat logs/logfile at this time you can view the data directory, the corresponding configuration file and directory have been generated. Start the database pg_ctl -D /u01/data/postgres/data/ -l /u01/data/postgres/logs/logfile start You can now start the database server using: pg_ctl -D /u01/data/postgres/data/ -l logfile start You can print the following information to Success. Switch the user to initialize the database, and then start the database su - postgres Check the directory structure cd postgres]# llĭrwxr-xr-x 2 root root 4096 June 01 15:59 binĭrwxr-xr-x 6 root root 4096 June 01 15:59 includeĭrwxr-xr-x 4 root root 4096 June 01 15:59 libĭrwxr-xr-x 6 root root 4096 June 01 15:59 shareĬonfigure environment variables and directory permissions vi /etc/profileĥ. OK,now PostgreSQL installation is completeģ. Make install is successful, it will print as follows Information: The make make process is time-consuming.Īll of PostgreSQL successfully made. You can also see the help information related to a compilation by make/ make -help. If the compilation fails, install the corresponding package according to the prompt message yum. You can continue without error reporting. Note: If you do not specify an installation directory, it will be installed under /usr/local/ by default. configure -prefix=/u01/data/postgres -without-readline If you want to install postgresql 11 v11, it is as follows:Ģ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |