Page 1 of 1
Selective Export in a backwards way?
Posted:
Fri Jan 30, 2009 6:45 am
by SwizzleStack
Since we currently don't have a selective export, but we do have a selective purge, could I make a copy of the my whole database (using pgdump I'm assuming, dump & restore), then selectively purge what I don't want. So in a roundabout way, it would be kind of like a selective export (and then having those files imported into a new db)? I
Re: Selective Export in a backwards way?
Posted:
Fri Jan 30, 2009 11:02 am
by kraada
Yes, that would do it.
If you feel comfortable at the command line, though, see
this thread to get you started.
Re: Selective Export in a backwards way?
Posted:
Fri Jan 30, 2009 3:03 pm
by SwizzleStack
Much simpler! Thanks
(is simpler a word? more simple? whatever)
Re: Selective Export in a backwards way?
Posted:
Fri Jan 30, 2009 3:18 pm
by kraada
Yes, it is a word, and you're welcome.
Not everyone feels comfortable with the command line, so it's not easier for some -- but I'm glad it works well for you
Re: Selective Export in a backwards way?
Posted:
Fri Jan 30, 2009 11:25 pm
by SwizzleStack
I'm like most. If there's a gui that I can be lazy--point, click, & drag, I'll probably use it, but you gotta do what you gotta do! In fact, I've been trying to learn some Ruby on Rails as it seems a really powerful and overall, pretty intuitive way to work with databases (among other things).
Re: Selective Export in a backwards way?
Posted:
Sat Jan 31, 2009 10:10 am
by kraada
I've never tried Ruby on Rails personally; I learned Python back in the day and PHP when it was useful . . . I've heard plenty about Ruby on Rails though and maybe one of these days I'll look into it
(For the record, the "average person" has never heard of Ruby on Rails, I assure you.)
Re: Selective Export in a backwards way?
Posted:
Sat Jan 31, 2009 2:56 pm
by gspeers
kraada wrote:Yes, that would do it.
If you feel comfortable at the command line, though, see
this thread to get you started.
When I use the command line approach - am I doing this through PT3 or am I doing directly to Postgres database?
Re: Selective Export in a backwards way?
Posted:
Sat Jan 31, 2009 3:42 pm
by kraada
Directly through the PostgreSQL database; there isn't an interface for selective export in PT3 yet so that's the only way to manage it.