( Credit) Step 6: Changing the UNIX Socket Directories Value (Optional)ĭo you intend to have the PostgreSQL daemon auto start after your Alpine Linux LXC container boots up? If yes, do this step. ~ $ echo "listen_addresses='*'" > /var/lib/postgresql/data/nf
#Astralinux postgresql mac password
Step 5: Allow Remote Connections via Password Authentication (Optional)ĭepending on your needs, you may want to allow remote connections to this PostgreSQL database instance: ~ $ echo "host all all 0.0.0.0/0 md5" > /var/lib/postgresql/data/pg_hba.conf auth-local and -auth-host, the next time you run initdb. You can change this by editing pg_hba.conf or using the option -A, or WARNING: enabling "trust" authentication for local connections 18:17:25.809 UTC WARNING: no usable system locales were found Performing post-bootstrap initialization. Selecting dynamic shared memory implementation. The default text search configuration will be set to "english".įixing permissions on existing directory /var/lib/postgresql/data. The default database encoding has accordingly been set to "UTF8". The database cluster will be initialized with locales This user must also own the server process. The files belonging to this database system will be owned by user "postgres". We will use this to, as the name suggests, initialize the database: ~ $ initdb -D /var/lib/postgresql/data
PostgreSQL’s initdb command helps us to setup the database instance and create a new PostgreSQL database cluster. Step 4: Create a New Database Cluster with initdb # Create the data directory, and make it less permissive PostgreSQL requires a folder to store its the database files, so lets create one: # Change to postgres user, and navigate to its home directory Step 3.2: Data folder for the database system However, if you intend to have the PostgreSQL daemon auto start after the OS boots, then skip this sub-section for now. ~ # chown postgres:postgres /run/postgresql/
If having to manually recreate the folder and start the daemon after a reboot is fine with you, then do the following: ~ # mkdir /run/postgresql However, my experience is that when running Alpine Linux in an LXC container, changes in this folder does not persist between container restarts (same container, just stop/start). By default, this would be in the /run/postgresql directory. PostgreSQL requires a directory path for create and store its. Step 3: Create Required Folders for PostgreSQLĪt this point, we need to set up two folders for PostgreSQL: Step 3.1: Folder for PostgreSQL Socket Note: It is possible to combine these two steps into one, using the second command with the -no-cache flag.
#Astralinux postgresql mac apk
Step 2: Update Package Repository Index and Install the PostgreSQL Package ~ # apk update You can check the available versions of PostgreSQL at the Alpine Linux package repository.įor simplicity, I will use PostgreSQL 11.6 that is within the Alpine Linux v3.10 package repository. However, depending on your version of Alpine Linux and PostgreSQL required, you can explicitly specify the repository + PostgreSQL version to pull from. For example, Alpine Linux v3.10’s package repository only has PostgreSQL 11.6 available. Step 1: Determine PostgreSQL / Alpine Linux VersionĮach version of Alpine Linux uses a different official package repository, with each having a specific of PostgreSQL.
0 kommentar(er)
