How does initdb of PostgreSQL work? How to use it for testing?
Many suggestions for integration testing which includes Postgres Database say that I can initdb a new whole cluster in RAM disk and work on it.
As far as I understand initdb is a new folder like thing related to databases.
According to Postgres docs:
initdbcreates a new PostgreSQL database cluster. A database cluster is a collection of databases that are managed by a single server instance.
Does it create a new server? Or a new Database?
Creating a database cluster consists of creating the directories in which the database data will live, generating the shared catalogue tables (tables that belong to the whole cluster rather than to any particular database), and creating the template1 and Postgres databases. When you later create a new database, everything in the template1 database is copied. (Therefore, anything installed in template1 is automatically copied into each database created later.) The Postgres database is a default database meant for use by users, utilities and third party applications.
Does the above sentence mean that from now on whatever database is created it is stored in that new "cluster"? If not how to create tables in such a cluster of RAM disk?
How can I use it to set it up for testing?
In the terminology your image uses (from pgAdmin?), initdb would create the data directory for a new “server”.
In PostgreSQL, this is not called a server, but a database cluster. It has a data directory, which is created with initdb. If you start the cluster with pg_ctl start, a PostgreSQL server process (called postmaster) is started, which listens for incoming connections and starts backend processes that work on the data directory.
There can be more than one PostgreSQL database clusters on one machine, you just have to give them different port numbers.
It should be no problem to run initdb to create a database cluster for your integration tests. After initdb you have to edit postgresql.conf appropriately (e.g. to set port) and start the postmaster with pg_clt start -D <data directory>.
- Postgres import dump ignoring duplicates
- Multi-Tenant Spring boot web application
- How to perform read queries on read replica in postgres?
- How can I query what security labels exist on a table?
- PostgreSQL, bulk update using data from another table
- Django 5.1 + Postgresql (debian server)
- How to use values from CTE in ON CONFLICT UPDATE
- Can't build Docker image with Postgresql
- checking java date with postgresql timestamp without timezone
- Enable debugging of postgresql functions on database inside a docker container using pgAdmin
- TypeORM: Custom Many To Many Relationship
- Delete json object from jsonb type column based on key of json object in postgresql
- Docker runs PostgreSQL in "trust" mode
- How to fix Postgres error "operator does not exist" using pgvector
- Rails 4 scope NOTNULL refactor
- postgreSQL index not found why?
- Select on self-referencing table where all chains meet a condition
- How to successfully save data to another database column in postgresql using jetpack compose?
- In a join, fields with null values are not getting shown but in normal query they are
- Install pgAgent on AWS RDS for Postgres
- Spring JBDC bad SQL grammar on PostgreSQL
- Using IF in function for different queries as a result
- Variables in looping condition in a postgreSQL while loop
- SQL query for returning rows with only certain values in list but not others?
- How to insert data into a code-first database with a SQL script?
- How do I insert a record into a Postgres DB based off the MAX of one column?
- Pyspark JDBC read with partitions
- Quarkus dev postgresql container not shutting down with quarkus
- Permission issue with PostgreSQL in docker container
- Starting application development using Docker or configuring Docker during development?