473,498 Members | 2,018 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

relfilenodes

1 New Member
I am replicating a table via slony. I know the relfilenode of the table from pg_class but a new disk file is created with a different relfilenode. After the copy is complete, the relfilenode for the table is updated with the new number. Is there a way to know the "temporary" or "new" number while it is copying?

For example, table xxx is being replicated from node 1 to node 2. The relfilenode from pg_class on node 2 for table xxx is 123456. After the replication is complete, pg_class:relfilenode is updated to 234777. Is there a way to determine the relname of 234777 while it is replicating and before relfilenode is updated for table xxx? pg_class does not know about 234777 while the replication is taking place.

Any help is appreciated.
Sep 26 '06 #1
0 925

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.