Re: Database setup for pgarchives

On 7/20/22 14:12, Sahil Harpal wrote:
> Hello everyone,
> I am working on the improvement of pgarchives project as a part of GSoC.
> I need help in database initialization. Do anyone have a database
> initialization script which will create all the required tables and
> fills it with sample data? Because what I observed the simple migration
> is not actually creating all the tables. Like table list_months is not
> getting created during migration process.

Hi Sahil, I've also been playing with a local pgarchives setup recently.
I ended up using loader/sql/schema.sql in that repository to create some
of the missing tables, and then the migration scripts to fill the rest
in. Hopefully someone knows of an easier or more straightforward way.

> Also can I get some sample real word data that can be dump from the
> current database? I tried inserting some sample data but may be due to
> some internal constraints/dependency with other tables/info it is
> not working properly and giving error on accessing mail threads.
> It would be realy helpful if I get database initialization script which
> will create all required tables and some sample real world data that I
> can use for testing.
> I am planning to make the new design open for the discussion by puting
> link of test server but without data nothing will be visible.
> Also would love to know any other possible method/technique for this.

I am also interested in the answer to this, but unfortunately I don't
have much advice to offer. My local setup contains manually inserted
rows as well. I tried to use loader/pglister_sync.py as a bit of a
guide. The Django admin interface also helped a little bit (for example
with list creation), but in the end I had to construct queries for the
remaining pieces.

--Jacob