Page 1 of 1

Selective Export in a backwards way?

PostPosted: 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?

PostPosted: 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?

PostPosted: 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?

PostPosted: 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?

PostPosted: 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?

PostPosted: 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?

PostPosted: 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?

PostPosted: 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.

highfalutin