Skip to content

Instantly share code, notes, and snippets.

@marcocitus
Last active June 8, 2020 08:20
Show Gist options
  • Save marcocitus/e692f48d534d324c845587f5741551ac to your computer and use it in GitHub Desktop.
Save marcocitus/e692f48d534d324c845587f5741551ac to your computer and use it in GitHub Desktop.
Downgrade from 9.3-1 to 9.2-2
DROP FUNCTION pg_catalog.citus_extradata_container(INTERNAL);
CREATE FUNCTION pg_catalog.citus_extradata_container(INTERNAL)
RETURNS void
LANGUAGE C
AS 'MODULE_PATHNAME', $$citus_extradata_container$$;
COMMENT ON FUNCTION pg_catalog.citus_extradata_container(INTERNAL)
IS 'placeholder function to store additional data in postgres node trees';
DROP FUNCTION IF EXISTS pg_catalog.update_distributed_table_colocation(regclass, text);
Instructions to downgrade from v9.2.3 to 9.2.2:
1. Install Citus v9.2.2
2. Copy citus--9.3-1--9.2-2.sql to <postgresql installation directory>/share/extension/citus--9.3-1--9.2-2.sql
3. Restart PostgreSQL
4. Run: ALTER EXTENSION citus UPDATE;
5. Delete <postgresql installation directory>/share/extension/citus--9.3-1--9.2-2.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment