citusdata / citusdata/pg_cron

Error on creating extension in pipeline db

Open
#57 5 comments 7 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

Hi,

I have installed pipeline (9.5.3) in my mac.
```
$ pipeline-ctl -V
pg_ctl (PostgreSQL) 9.5.3
$
```

Also added the below in /usr/local/lib/pipelinedb/data/pipelinedb.conf which is an equivalent of postgres.conf.
```
shared_preload_libraries = 'pg_cron' # (change requires restart)
cron.database_name = 'pipeline'
```

Did restart the pipelinedb using below
```
pipeline-ctl -D pipelinedb-data/ -l logfile restart
```
Still getting below error
```
$ psql -p 5432 -h localhost pipeline
psql (9.5.3)
Type "help" for help.

pipeline=# CREATE EXTENSION pg_cron;
ERROR: unrecognized configuration parameter "cron.database_name"
CONTEXT: PL/pgSQL function inline_code_block line 3 at IF
pipeline=#
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.