We've used Pentaho Data Integration (aka Kettle) at http://kettle.pentaho.org to
do this in the past. (Kettle is the free / open source version, although there
is a bigger commercial version of PDI that does more.) It reads XML nicely and
talks natively to PostgreSQL databases, so you can load
Possible xid rollover problem? (We saw behavior similar to this during a recent
xid rollover fiasco, where tables didn't appear in the various catalogs and psql
catalog commands, but the data was still there.)
What version of PostgreSQL are you on?
If you try a VACUUM on the pg_catalog.pg_class
On Friday, August 07, 2009 12:44 PM, Joshua D. Drake wrote:
On Fri, 2009-08-07 at 17:36 +0100, Sam Mason wrote:
On Fri, Aug 07, 2009 at 11:11:10AM -0500, Wenjian Yang wrote:
We currently installed emacs 23.1 and PostgreSQL 8.4.0 for Windows on a
windows desktop. When issue sql-postgres in
MS's web site has a good summary at
http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/w2000Msgs/60
93.mspx?mfr=true . Their bottom line: Faulty hardware, a buggy system
service, antivirus software, and a corrupted NTFS volume can all generate this
type of error.
If you haven't
Use select pg_cancel_backend(pid) instead -- we have to do this periodically
when queries get timed out by the web server but Postgres doesn't notice /
doesn't get notified...
- Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Howard Cole
Sent:
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 3:25 PM
To: Bill Bartlett
Cc: 'Andreas Kretschmer'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we
Quick request to the group: we have several members who include bogus or
humorous X-Message-Flag headers in their email messages. Could I
request that you _please_ turn them off? Because they come through as
flagged messages in Outlook, it throws off my email rules processing
and the messages
them off
am Fri, dem 05.10.2007, um 10:05:32 -0400 mailte Bill
Bartlett folgendes:
Quick request to the group: we have several members who
include bogus
or humorous X-Message-Flag headers in their email
messages. Could I
request that you _please_ turn them off? Because they come
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 10:45 AM
To: Bill Bartlett
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please turn them off
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 12:30 PM
To: Bill Bartlett
Cc: A. Kretschmer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please turn
turn them off
Bill Bartlett [EMAIL PROTECTED] schrieb:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
A. Kretschmer
Sent: Friday, October 05, 2007 10:57 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone
, September 20, 2000 11:00 AM
To: Bill Bartlett; 'johnf'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Building Windows fat clients
Glad to hear that
I knew Novell *was* working on a port to BSD
But I havent heard about ports to other Nix platforms?
M--
- Original Message
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Martin Gainty
Sent: Tuesday, September 19, 2000 5:58 PM
To: johnf; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Building Windows fat clients
Hello Guys
Using C# means .NET framework
For quick/simple table format reports, you can just use psql to create
the output in HTML format, then import that directly into Excel. For
example, I use the following psql line to generate an HTML-format report
of server IP information; this file can then be directly opened in
Excel. (Excel
Couldn't this be offered pre-built as an alternative in the Windows
installer or as a psql2.exe program? Seems like there might be more
than a few PostgreSQL users running with US keyboard layouts under
native Windows, and providing the prebuilt version along with the
normal one might eliminate
We use the Cygwin version of the psql.exe program under Windows instead
of the native psql.exe program, even though the rest of the PostgreSQL
installation uses the standard native Windows versions of all the other
PostgreSQL components (database, tools, etc.). (So before I get flamed,
I want to
The Windows Server 2003 Resource Kit and WinXP Resource Kit (both free
to download) both also provide the LINKD utility -- we use LINKD to
create junctions on most of our Windows servers (to mimic the equivalent
hard links we use on our Linux servers).
- Bill
-Original Message-
From:
Is anyone aware of any issues with running PostgreSQL 8.0.4 on a Windows
2003 Server x64 system? (I know it's an old DB version that we will
eventually upgrade to 8.1.x or 8.2.x, but it's running on a production
system where for the immediate future I don't have the time to test on
any of the
Assuming you are logged on to the XP workstation with an
administrator-level account, you should also be able to do
net user postgres /delete
from the XP command line to delete the postgres user account that was
created by the old installation.
- Bill
-Original Message-
From:
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 2:46 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres and emacs on windows os
hi all,
has anybody experience using psql with emacs (M-x sql-postgres) on
Are you connecting to the console session on your Win2K3 server or to
one of the other two available remote desktop sessions? (To connect to
the console session using the RDP client from XP, you need to inclde
/console at the _end_ of your command line: ie: mstsc
/v:MyRemoteServerName /console.
The Silent install of PostgreSQL on Windows document states that The
service user needs Log on as a service, Log on locally and Access this
computer from the network. If the PostgreSQL database will only be
accessed via localhost, are these permissions still required after the
installation has
Bill Bartlett wrote:
I hit this exact same problem, and my initial reaction was
the same as
yours -- psql was hanging. After much head-banging, I discovered
that it is not in fact hanging, but is instead getting confused by
being run from inside Putty, Cygwin, xterm, rxvt terminal
to compile it
yourself. I'm also planning on doing this too, but I haven't had the
time.
- Bill
Bill Bartlett
meridianEMR, Inc.
http://www.meridianemr.com/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Richard van den Berg
Sent: Friday, November 04
Given both the naming of Oracle 10g Express and the timing of Oracle's
announcement, I think Oracle Express is more of a reaction to pressure
by Microsoft's SQL Server 2005 Express, due to be released Nov 7 but
actually shipped to developers this past Thursday.
I've been a DBA for _many_ years on
[snipped]
May not be the best choice on Windows for production use, though for
development, it should be adequate.
Are there known issues with the Windows version for production use, or
is this simply because of the relative newness of the Windows-native
version?
- Bill
26 matches
Mail list logo