RuntimeError: command not found: initdb

[Priyadhana]

Hi , I wanted to write test-cases involving postgres for flask applicattion. When I was trying the testing.postgresql package, it's throwing this command not found: initdb error.
This is the code I'm trying,

import unittest
import testing.postgresql

Generate Postgresql class which shares the generated database

Postgresql = testing.postgresql.PostgresqlFactory(cache_initialized_db=True)

def tearDownModule(self):
# clear cached database at end of tests
Postgresql.clear_cache()

class MyTestCase(unittest.TestCase):
def setUp(self):
# Use the generated Postgresql class instead of testing.postgresql.Postgresql
self.postgresql = Postgresql()

def tearDown(self):
    self.postgresql.stop()

When I ran pytest, I'm getting this error,

src\tests\app\test_db.py:25: in
Postgresql = testing.postgresql.PostgresqlFactory(cache_initialized_db=True)
..\user\appdata\local\programs\python\python39\lib\site-packages\testing\common\database.py:52: in init
self.cache = self.target_class(**settings_noautostart)
..\user\appdata\local\programs\python\python39\lib\site-packages\testing\common\database.py:92: in init
self.initialize()
..\user\appdata\local\programs\python\python39\lib\site-packages\testing\postgresql.py:50: in initialize
self.initdb = find_program('initdb', ['bin'])
..\user\appdata\local\programs\python\python39\lib\site-packages\testing\postgresql.py:144: in find_program
raise RuntimeError("command not found: %s" % name)
E RuntimeError: command not found: initdb

I have set the path for "C:\Program Files\PostgreSQL\13\bin" in my environmental.

Am I missing something? Can someone help me out here.

[saveshodhan]

See if #35 helps..

[asmaier]

You need to install the postgres DB. On Mac OS simply do

brew install postgresql

Maybe the documentation should mention this as a requirement for the installation.

[anentropic]

after brew install postgresql I get a new error:

RuntimeError: command not found: postgres

brew info postgresql doesn't suggest anything wrong, but the fix for me was:

$ brew link postgresql
Linking /opt/homebrew/Cellar/postgresql@14/14.5_3.reinstall...
Error: Could not symlink bin/clusterdb
Target /opt/homebrew/bin/clusterdb
is a symlink belonging to libpq. You can unlink it:
  brew unlink libpq

To force the link and overwrite all conflicting files:
  brew link --overwrite postgresql@14

To list all files that would be deleted:
  brew link --overwrite --dry-run postgresql@14

$ brew link --overwrite postgresql@14
Linking /opt/homebrew/Cellar/postgresql@14/14.5_3.reinstall... 334 symlinks created.