[ADMIN] Problem with FDW in pgadmin
I've installed the odbc_fdw extension and I've got a DB2 ODBC driver installed. When I try the instructions at http://interdbconnect.sourceforge.net/pgsql_fdw/pgsql_fdw-en.html to create a server object, I don't get any errors reported, and I appear to have successfully created a foreign table, but I don't see either the server or the foreign table in the object browser. CREATE SERVER remote_db FOREIGN DATA WRAPPER odbc_fdw OPTIONS (dsn 'DB2DSN'); CREATE USER MAPPING FOR postgres SERVER remote_db OPTIONS (username 'jforeman', password 'this-is-a-secret'); CREATE schema remote_query; CREATE FOREIGN TABLE remote_query.tpids (tpid int) SERVER remote_db OPTIONS (database 'DB2DSN', sql_query 'SELECT TPID FROM DM.V_TPID_DIM.TPID'); All these are apparently fine, although I can't find the foreign table anywhere (it's not visible in the tables in the remote_query schema) on pgAdmin. The foreign table has a few hundred rows - it's not anything massive that should take a long time to query. Then I try SELECT * FROM remote_query.tpids And the result is *Error ** no connection to the server Connection reset. After that, I have no connection to the postgres server, and have to restart the machine before I can reconnect - attempting to use the FDW apparently breaks my existing connection, and prevents me creating any new ones. 2 questions: should I be able to see the foreign table object? It definitely exists, because if I were to try rerunning the CREATE FOREIGN TABLE command I get an error reporting that it already exists. Secondly, where should I look to figure out why running the select statement kills the connection, and stops me making any new connection? Thanks James
Re: [BUGS] [ADMIN] Repeatable crash in pg_dump (with -d2 info)
On Tue, Jan 17, 2012 at 04:46:50PM -0500, David Schnur wrote: I finally had time to test this further on a variety of systems, and was unable to reproduce on any non-Windows platform. The dump even works fine on Windows XP; just not Windows 7. This prompted me to do a little more research, and this time I found this thread from Sept. 2011: http://postgresql.1045698.n5.nabble.com/ BUG-6233-pg-dump-hangs-with-Access-Violation-C005-td4851598.html From Tom Lane in the above thread: Hmm. I can see how that would happen if you're using one of the Windows environments wherein malloc's done inside libpq have to be free'd inside libpq. (The PQExpBuffer support code is in libpq...) However, the flaw in that explanation is that it would basically mean pg_dump doesn't work at all on Windows, at least not if you have any user-defined functions, and probably some other cases too because there seem to be multiple instances of the dubious coding. It's a bit hard to believe that nobody's noticed that before. This appears to describe exactly the issue I'm encountering, and my build is in fact linked against the static runtime. I guess the reason this hasn't come up sooner is because most Windows users either use the 'official' binaries rather than compiling from source, or link against the dynamic runtime. Is this something I could expect to be fixed in the near future, or is it enough of an edge case that I should come up with some solution or work-around on my own? Thanks, Late reply, but I don't see any way we could fix this easily. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Looking for a better approach for pacemaker, DRDB VS pgsql 9.1 standby feature.
Hi there, I am setting up a 2 node database cluster (Master/standby) on pgsql 9.1 and it looks to me that drdb option could be easier to maintain keep running after several failovers on a row, specially because after a failover operation it is not too friendly to set back up automatically the former primary as the new standby. Besides I would not like to automate an rsync over the same data directory as it could be destroyed by a 'wrong' syncing . Any comments are welcome ! Thanks in advance, A.A. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Fwd: Delivery Status Notification (Failure)
btw, why the mail server rejected me many times? is it marked as spam? : Delivery Status Notification (Failure) : Tue, 28 Aug 2012 01:55:01 + : Mail Delivery Subsystem mailer-dae...@googlemail.com : ruralhun...@gmail.com Delivery to the following recipient failed permanently: pgsql-admin@postgresql.org Technical details of permanent failure: Google tried to deliver your message, but it was rejected by the recipient domain. We recommend contacting the other email provider for further information about the cause of this error. The error that the other server returned was: 550 550 unknown address (state 13). - Original message - DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=6c8hoX5Vl3yHCboxcNI156fIiguPMoLh1tgPbdomtCg=; b=Aedu3K7NmOHqW3YFwwQZu6YCER/DmdMt+xzf1by+41EUWLIgWrgU1QLGm7vYKM06fh KHXHZ3iAltO2qAzWoYSKqkN8BklyukHf67U1BhUznJLPxT60aGtBGCxW9BbBj9EtTyK5 8Ee0ihOaX1Vce36hTE8N6qmd63TlUguscd+3ScX5djsSpbvhkpFk9wG50BfZRmJN0/dP zRYyS+sPmqpaO3z3ysefu9SyGnBrHafCfRDEGZ2ahSmvpXgT+OsK4zzJS0QgIoUqli2d JFdX1Vl12mWBptlA4N6MTzNpg4rAXVWUSyLQOn8A7y4fE9otskZvxwI4QVMUSrLbGZY/ N1Zg== Received: by 10.66.76.106 with SMTP id j10mr25362006paw.51.1346118900365; Mon, 27 Aug 2012 18:55:00 -0700 (PDT) Return-Path: ruralhun...@gmail.com Received: from [192.168.1.8] ([116.226.69.188]) by mx.google.com with ESMTPS id sr3sm15887340pbc.44.2012.08.27.18.54.57 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 27 Aug 2012 18:54:58 -0700 (PDT) Message-ID: 503c24ec.3030...@gmail.com Date: Tue, 28 Aug 2012 09:54:52 +0800 From: Rural Hunter ruralhun...@gmail.com User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Analyze on Children Tables Content-Type: text/plain; charset=gb18030; format=flowed Content-Transfer-Encoding: 7bit I'm on pg 9.1.3. When I analyze verbose on parent table, I see all the children are analyzed in the log. But I found the last analyzed time of children tables are not changed. So my question is, after I analyzed the parent, should I re-analyze children tables?