Stack Overflow
Stack Overflow

Questions tagged [postgresql-initdb]

17 questions
3
votes
1 answer

Docker Container: Relation X doesn't exist in database

I am developping a java application, I created an image of the database PostgreSQL by using docker. I have a folder "docker-entrypoint-initdb.d" which contains files to create tables, data. When I launch my application, I get this…
Nabila NAB
  • 43
  • 3
3
votes
1 answer

How to create a temporary database with postgresql initdb?

How do I create a temporary database for PostgreSQL using initdb? Also, how do I populate it with dummy data and how do I delete it after usage? I have an entire schema of the database. I don't want to create temporary tables one by one. Using…
Tarun Maganti
  • 3,076
  • 2
  • 35
  • 64
2
votes
1 answer

Postgresql initdb - Segmentation fault (core dumped)

I did some changes of pgsql source code, such as adding a new system catalog. Then I wanted to init the database by using initdb -D PG_DATA_PATH. But it came to this problem: The files belonging to this database system will be owned by user…
Charlie_Y
  • 23
  • 3
2
votes
1 answer

set initdb encoding for postgres

When I try to call pg_ctl with init[db] the option for setting the encoding is not recognized: pg_ctl init -D=D:\testdata -E=UTF8 -U=postgres pg_ctl: illegal option -- E Has this changed? I used latest PostgreSQL 9.6 (zip download, x64). When I…
Beachwalker
  • 7,685
  • 6
  • 52
  • 94
1
vote
2 answers

initdb: error: program "postgres" is needed by initdb but was not found using circleci ubuntu docker-compose docker-entrypoint-initdb.d

I am using docker-compose on circleci to spin up a postgres container with a bunch of sql files mounted on /docker-entrypoint-initdb.d/. I am using an ubuntu machine image: ubuntu-2004:202010-01, but I am getting the error: popen failure: Cannot…
valcapp
  • 293
  • 3
  • 8
1
vote
1 answer

Initdb - Initialize a new database cluster has stopped working (Windows PostgreSQL Installation)

It's been more than three days, I have tried all the the solutions below, postgres installation the database cluster initialization failed ( Postgresql Version 9.4.4…
Sudheer Tripathi
  • 83
  • 8
1
vote
1 answer

initdb error on PostgreSQL 10 - RHEL 6

Installed PostgreSQL 10 on RHEL 6 system by running the following commands: rpm -Uvh --force --nodeps postgresql10-libs-10.0-1PGDG.rhel6.x86_64.rpm rpm -Uvh --force --nodeps postgresql10-10.0-1PGDG.rhel6.x86_64.rpm rpm -Uvh --force --nodeps…
P_Ar
  • 377
  • 2
  • 9
  • 25
1
vote
0 answers

Postgres image from docker can't find initdb. What am I missing?

I'm on windows 10 with docker version 1.9.1 using docker toolbox I wanted to put up a quick postgres container, something I've done before with a dockerfile I had laying around. FROM postgres ADD create-db.sql /tmp/ ADD drop_create_table.sql…
Oliver
  • 381
  • 1
  • 4
  • 11
0
votes
1 answer

While upgrading Airflow version 2.0.0 to 2.2.5 got an error in initdb. the log is attached below

*While upgrading Airflow version 2.0.0 to 2.2.5 got an error in initdb. the log is attached below. * category=DeprecationWarning, /usr/local/lib/python3.6/site-packages/airflow/configuration.py:361: DeprecationWarning: The logging_level option…
subrat nayak
  • 21
  • 4
0
votes
0 answers

PostgreSQL `initdb` permission denied with `rwx` permissions and logged as postgres

I want to set up a PostgreSQL database but initdb hits an authentication error. I seem to be doing as described in docs. I log in as postgres user with doas -u postgres -s (AFAIK it's same as su - postgres) cd to /home/user/A/B/postgres. stat .…
zaabson
  • 151
  • 12
0
votes
2 answers

Postgres initdb: How to set logging_collector=on in the generated postgressql.conf file

The default postgresql.conf file created using initdb contains the following line #logging_collector = off # Enable capturing of stderr and csvlog Is there anyway to force initdb itself to generate a file with logging_collector = on rather than…
mark d drake
  • 1,280
  • 12
  • 20
0
votes
0 answers

initdb in Postgres.app does not create postgres &template1 database

I installed postgres.app 2.4.2 on macos(big sur 11.4). I wanted to initdb with locale=C, so run the command initdb -D "/Users/xxx/Library/Application Support/Postgres/var-131" -U postgres --encoding=UTF-8 --locale=C --auth-local=trust and the…
Jack Tang
  • 59
  • 5
0
votes
0 answers

PostgreSQL initdb initialize a new database cluster has stopped working

During install of PostgreSQL using binary zip file , this error occurs , when i try to run this command initdb.exe -U postgres -A password -E utf8 -W -D C:\pgsql\data. Error Message: "initdb initialize a new database cluster has stopped…
Dragon
  • 1,078
  • 2
  • 9
  • 31
0
votes
2 answers

Initializing data directory for postgresql not successful

I tried to initialize the postgresql data directory, and I get this error : [postgres@vix-db1-1 ~]$ /usr/pgsql-9.5/bin/initdb --nodename=vix-db1-1 -D /var/lib/pgsql/9.5/data The files belonging to this database system will be owned by user…
anaigini
  • 11
  • 2
0
votes
0 answers

initdb.exe failed suddenly (Windows)

My application bundles PostgreSQL 9.5.0 and runs initdb.exe manually. It works fine in the most clients. This A client also installed my application successfully before, but after rebooting their Windows (2008), they got below error. They…
Sigularity
  • 917
  • 2
  • 12
  • 28
1
2