Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for backing up new schema setup of Postgres DB for Eucalyptus 4.1 #69

Closed
hspencer77 opened this issue Jan 23, 2015 · 2 comments
Assignees

Comments

@hspencer77
Copy link
Member

In Eucalyptus 4.1, the database has a different layout (see EUCA-9617). Layout in 4.1 is as follows:

              List of schemas
             Name              |   Owner
-------------------------------+------------
 eucalyptus_auth               | eucalyptus
 eucalyptus_autoscaling        | eucalyptus
 eucalyptus_cloud              | eucalyptus
 eucalyptus_cloudformation     | eucalyptus
 eucalyptus_cloudwatch         | eucalyptus
 eucalyptus_cloudwatch_backend | eucalyptus
 eucalyptus_config             | eucalyptus
 eucalyptus_dns                | eucalyptus
 eucalyptus_faults             | eucalyptus
 eucalyptus_general            | eucalyptus
 eucalyptus_imaging            | eucalyptus
 eucalyptus_loadbalancing      | eucalyptus
 eucalyptus_osg                | eucalyptus
 eucalyptus_records            | eucalyptus
 eucalyptus_reporting          | eucalyptus
 eucalyptus_reporting_backend  | eucalyptus
 eucalyptus_simpleworkflow     | eucalyptus
 eucalyptus_storage            | eucalyptus
 eucalyptus_walrus             | eucalyptus
 public                        | eucalyptus

Since this is the case, dumps from the database need to be done per schema. For example:

# pg_dump -p 8777  -h /var/lib/eucalyptus/db/data -n  eucalyptus_autoscaling eucalyptus_shared

This update needs to occur in the eucadb module.

@aveekbu
Copy link

aveekbu commented Feb 9, 2015

/usr/pgsql-9.2/bin/pg_dump -c -o -h /var/lib/eucalyptus/db/data -p 8777 -U root eucalyptus_shared -n eucalyptus_walrus -> work like charm. Only change needed to bring is pgsql9.2 and "eucalyptus_shared -n" with existing :)

@hspencer77
Copy link
Member Author

Fixed by PR #79

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants