docs icon indicating copy to clipboard operation
docs copied to clipboard

[Feedback] Page: /migrate/latest/pg-dump-and-restore/pg-dump-restore-from-timescaledb/

Open RyKilleen opened this issue 1 year ago • 1 comments

Is it easy to find the information you need?

The straight-forward steps of how to pg_dump / pg_restore to another timescale instance are scattered through the page, some times interjected with lots of special-case, not relevant info.

Are the instructions clear?

There are many caveats on how to proceed through the docs, which has a pretty high cognitive load.

How could we improve the Timescale documentation site?

Currently, after following the instructions as directed, you still receive an error resembling the following when attempting to pg_restore to a local docker instance of Timescale:

psql:dump.sql:6162: ERROR:  role "tsdbadmin" does not exist
CONTEXT:  COPY bgw_job, line 1, column owner: ""tsdbadmin""
psql:dump.sql:6162: STATEMENT:  COPY "_timescaledb_config"."bgw_job" ("id", "application_name", "schedule_interval", "max_runtime", "max_retries", "retry_period", "proc_schema", "proc_name", "owner", "scheduled", "fixed_schedule", "initial_start", "hypertable_id", "config", "check_schema", "check_name", "timezone") FROM stdin;

RyKilleen avatar Feb 28 '24 17:02 RyKilleen

Thank you for the report. We welcome documentation contributions!

  • For information about how to propose a change, see the contributing guide in our GitHub repository.
  • For information on style and word usage, see the style guide

github-actions[bot] avatar Feb 28 '24 17:02 github-actions[bot]