Postgres data copy issue

[santosh_ghalsas]

Hi,

I have been working on a recently setup private cloud instance of Apigee and trying to copy data from postgres fact table to other location in order to free memory space. I am using commands from below link to do the same. -

https://community.apigee.com/content/kbentry/38184/apigee-private-cloud-1507-how-to-clean-up-postgre...

I am not able to execute the copy command to transfer data for last 5 days from fact table. It just does not give any error or any output and just jumps on the command line. Can anyone know what steps can be used to debug this issue.

Thanks,

Santosh

[santosh_ghalsas]

Hi,

I was looking for data only in the parent fact table and that was not having any data for some reason. Once I changed the command to look into all the child tables then I was able to achive this. Can anyone let me know why was the parent table not containing the data as mentioned in the article?

Thanks,

Santosh