Re: [GENERAL] exporting postgre data
On 25/01/2008 16:51, johnf wrote: The issue I have with pgAdmin3 and backing up a table is with the restore. The associated sequences are not restored. Granted that might be a different problem. But from a users perspective I see it as a major problem. Oh? Works fine for me, on PG 8.2.5 - pg_dump exports the SQL to recreate the sequence, and a setval() to reset it to where it was. Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] exporting postgre data
On Friday 25 January 2008 07:21:34 am Harald Armin Massa wrote: > Bill, > > pgadmin3 provides the same: just dig down to the table, use the backup > link and give the options. It also calls pg_dump just with the right > parameters, you can copy that command for a .cmd for professional > automatic backup. > > Best wishes, > > Harald > > > MSSQL has a fancy GUI "wizard". > > > > It basically does all the stuff pg_dump does, but just using a GUI > > interface to manage all the options. I guess it has the addition > > of managing the interaction between pg_dump on one server an pg_restore > > on another as well. > > > > Doesn't really have any more features that I'm aware of, just has a > > nice "one stop" interface. > > > > -- > > Bill Moran > > http://www.potentialtech.com > > > > ---(end of broadcast)--- > > TIP 6: explain analyze is your friend The issue I have with pgAdmin3 and backing up a table is with the restore. The associated sequences are not restored. Granted that might be a different problem. But from a users perspective I see it as a major problem. -- John Fabiani ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] exporting postgre data
On Fri, 25 Jan 2008 10:02:41 -0500 Bill Moran <[EMAIL PROTECTED]> wrote: > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of User > > > Map Sent: Friday, January 25, 2008 10:18 AM > > > To: pgsql > > > Subject: [GENERAL] exporting postgre data > > > > > > > > > is it posible to transfer data from postgres of one computer to > > > the postgres in another computer. In SQL server this is easily > > > done by the export utility of the sql server. > > > > > > > But how do you backup only a single table or transfer only a > > signle table. > > MSSQL has a fancy GUI "wizard". bcp does not provide the full set of goodiness but it works on the command line. I don't think it is suited for backup... just for exporting. It doesn't make too much sense working on the command line on Windows (unless you work with monad and such... but still) since the shell is quite limited up to my knowledge. But *nix guys may feel more comfortable with bcp. -- Ivan Sergio Borgonovo http://www.webthatworks.it ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] exporting postgre data
Bill, pgadmin3 provides the same: just dig down to the table, use the backup link and give the options. It also calls pg_dump just with the right parameters, you can copy that command for a .cmd for professional automatic backup. Best wishes, Harald > MSSQL has a fancy GUI "wizard". > > It basically does all the stuff pg_dump does, but just using a GUI > interface to manage all the options. I guess it has the addition > of managing the interaction between pg_dump on one server an pg_restore > on another as well. > > Doesn't really have any more features that I'm aware of, just has a > nice "one stop" interface. > > -- > Bill Moran > http://www.potentialtech.com > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] exporting postgre data
> > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of User Map > > Sent: Friday, January 25, 2008 10:18 AM > > To: pgsql > > Subject: [GENERAL] exporting postgre data > > > > > > is it posible to transfer data from postgres of one computer to the > > postgres in another computer. In SQL server this is easily done by the > > export utility of the sql server. > > > > But how do you backup only a single table or transfer only a signle table. MSSQL has a fancy GUI "wizard". It basically does all the stuff pg_dump does, but just using a GUI interface to manage all the options. I guess it has the addition of managing the interaction between pg_dump on one server an pg_restore on another as well. Doesn't really have any more features that I'm aware of, just has a nice "one stop" interface. -- Bill Moran http://www.potentialtech.com ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] exporting postgre data
JohnF, > But how do you backup only a single table or transfer only a signle table. please use pg_dump. You can find excellent documentation at http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html please pay special attention to the --table option. Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] exporting postgre data
On Friday 25 January 2008 02:56:12 am Gevik Babakhani wrote: > Check out the docs for pg_dump utility. > http://www.postgresql.org/docs/8.3/static/app-pgdump.html > > > _ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of User Map > Sent: Friday, January 25, 2008 10:18 AM > To: pgsql > Subject: [GENERAL] exporting postgre data > > > is it posible to transfer data from postgres of one computer to the > postgres in another computer. In SQL server this is easily done by the > export utility of the sql server. > > > > _ > > Never miss a thing. Make Yahoo > <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs> your > homepage. But how do you backup only a single table or transfer only a signle table. -- John Fabiani ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] exporting postgre data
Check out the docs for pg_dump utility. http://www.postgresql.org/docs/8.3/static/app-pgdump.html _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of User Map Sent: Friday, January 25, 2008 10:18 AM To: pgsql Subject: [GENERAL] exporting postgre data is it posible to transfer data from postgres of one computer to the postgres in another computer. In SQL server this is easily done by the export utility of the sql server. _ Never miss a thing. Make Yahoo <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs> your homepage.
[GENERAL] exporting postgre data
is it posible to transfer data from postgres of one computer to the postgres in another computer. In SQL server this is easily done by the export utility of the sql server. - Never miss a thing. Make Yahoo your homepage.
