Re: [ADMIN] dump from 9.0 to 8.3
On Tue, Jun 21, 2011 at 09:10:50AM +0300, Achilleas Mantzios wrote: Στις Monday 20 June 2011 18:46:33 ο/η Kevin Grittner έγραψε: Achilleas Mantzios ach...@matrix.gatewaynet.com wrote: is there any quick and dirty (or otherwise easy way) to have a smooth procedure to load into a 8.3 server data dumped by an 9.0 server ? I tried with pg_dump -i from the 8.3 server without good results. Your best bet might be to dump using the 9.0 pg_dump and then see where the errors are on the load attempt, and edit the file as needed. Thanx, unfortunately the dump is 310GB, and that rather forces me to go to the migration direction. I may get beaten up for this but... slony? :) Afaik should be doable. Your tables just need primary keys. -- A search of his car uncovered pornography, a homemade sex aid, women's stockings and a Jack Russell terrier. - http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-118083480 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] pgpool question?
On Wed, Sep 19, 2007 at 09:59:22PM -0700, Charles.Hou wrote: i have installed the pgpool in the server and start it. but how can i know it's working? i means that the clients connected to the database by the pgpool. The latest versions of pgpool2 (I don't use pgpool) have connection logging, so you could use that. You could use netstat (under linux and most other unixes) to see what host:port connections are going to. You could use strace (under linux) on either the software or pgpool to see if the software is connection to the right place and/or that pgpool is getting connections. Just some ideas. :) -- To the extent that we overreact, we proffer the terrorists the greatest tribute. - High Court Judge Michael Kirby ---(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: [ADMIN] Priviliges and Roles
On Mon, Feb 27, 2006 at 12:09:48PM +, Dayo Johnson wrote: Hello, Is it possible to do the following: Disallow permission to write to a table (either by UPDATE or INSERT) but allow EXECUTE permission on a Function that writes to the table ? The reason I want to do this is so that I can perform certain checks on the data that is being written before I allow it to be written. I'm no expert but check out triggers. That should allow you to whatnot the data and fail/pass the insert or update. See: http://www.postgresql.org/docs/8.1/interactive/triggers.html -- To the extent that we overreact, we proffer the terrorists the greatest tribute. - High Court Judge Michael Kirby ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Is this a Stupid Question ?
On Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith wrote: I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently remnants of 7.3.x are scattered around on the disk from (a) previous ports installation, causing mutex_lock/unlock, libpq.so and other installation problems. I want to reconfigure and reinstall. How do I know what, where all these fragments are located or how do I uninstall all of them or at least those that should be removed. If they're not installed with any sort of package management setup then one way to do this would be to compile it and install it into its own tree and then search out the files installed with find and remove them. -- Red herrings strewn hither and yon. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
