You need to take a look at the pg_dump command. You should do even if
you aren't interested in mirroring your content because this is the
command that you use to make backups of your PostgreSQL databases.
The easiest way to move your table would be to make a backup of your
product table on your development machine and restore it on your
internet connected machine.
If you don't understand what I am talking about, feel free to ask more
specific questions.
Another method would be to simply create a script that selects every
product in your product table on your development machine and either
updates the same row on your production machine (if it exists) or
inserts the row on your production machine if it does not exist. This
method has the added advantage of not requiring your product table to
be down for a bit.
Jason
waheed rahman <waheed_rahuman@yahoo.com> writes:
> Dear Sir
> How are you i am doing well here hope you the same
> from you.
> How is life there ?.I am expecting some help from you
> sir.
> I have one local machine with postgresql and orion
> ,which is for development and another internet
> connected machine with same postgresql and orion which
> is serving my website.
> Here in local machine and internet connected machine,
> (which is serving my website) i have a database named
> as mycompany.Now i will be entering data in local
> database
> in a particular table product.After that i have to
> synchronize this local db with internet machine
> db so that i will get both db with same data.
> How i can do this please help me in this regard.
> And please let me know how i can take backup for
> particular table alone from a db and
> how i can restore that data.
> Expecting your reply.
> Advance thankings for your reply.
> Regards
> waheed
>
> __________________________________________________
> Do You Yahoo!?
> Find the one for you at Yahoo! Personals
> http://personals.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)