Michael Vitale

Installation/Usage problems

2

I understand that the only way to use this is to do a git clone download, but it should be more straightforward in how to get it working. It is...

ora2pg incorrect syntax errors when compared to AWS SCT tool

2

The article by DB-BEST calls out a lot of errors with ORA2PG when compared to AWS SCT. https://www.dbbest.com/blog/comparing-ora2pg-with-aws-sct/#user-defined-type-declared-in-a-routine There appear to be a lot of them with exact script comparisons...

FATAL: in function put_in_order(): put_in_order: found existing elem

13

Error is: FATAL @src/objects.c:312 in function put_in_order(): put_in_order: found existing elem It happened while I was trying to log in with a user defined in userlist.txt. I noticed this error...

Using is_available return variable to determine if PG Ping is success or failure

15

I am running the postgresql_ping module in my playbook, and the postgresql server is not running on the target host. So I expect a failed result. Instead I just get...

Where is the task to install Postgres?

10

##### SUMMARY Where is the task to install postgres binaries and initialize a cluster?

COPY Error for PostGIS column table

4

@Brent-Wood : With this error: ERROR: Action: Copy Rows Diagnostics: line=COPY t_stratum_defn, line 19: "545,1,\N,\N,lhr1001,IQCH,\N,0106000020E61000000100000001030000000200000098060000B6B4CE57D5C16540B2B..." SQL statement "COPY trawl_dev2.t_stratum_defn FROM '/tmp/cloneschema.tmp' (DELIMITER ',', NULL '\N', FORMAT CSV);" PL/pgSQL function clone_schema(text,text,boolean,boolean,boolean)...

Dependency Problems

1

Currently, there is no dependency checking. For example, if a view is dependent on another view, they may not be created in the correct order during the clone operation resulting...

Big bloat discrepencies compared to pgstattuple

5

Using the table bloat checker here I get this on my database (PG 14): ``` current_database | schemaname | tblname | real_size | extra_size | extra_pct | fillfactor | bloat_size...

valid?

1

Is this repo valid anymore?

This is related to closed issue#30. I found a workaround by doing the **make install** bypassing **llvm**. `make install USE_PGXS=1 with_llvm=no` Without it: ``` /bin/mkdir -p '/usr/lib/postgresql/13/lib' /bin/mkdir -p '/usr/share/postgresql/13/extension'...