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 dat
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-po
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'
Use "select pg_cancel_backend()" 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: Thursda
> -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 /
> &q
; X-Message-Flag headers, could we please turn them off
>
>
> Bill Bartlett <[EMAIL PROTECTED]> schrieb:
>
> >
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of
> A. K
> -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
e-Flag headers, could we please turn 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
> -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-Fla
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
ty [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 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
> -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 fr
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 200
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 c
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 eliminat
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 late
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) o
> On 8/12/2006 Merlin Moncure <[EMAIL PROTECTED]> wrote:
> the .net 'way' of database application development is to keep
> all the logic in the .net middleware. please note that I am
> completely opposed to this because it obfuscates good data
> management practices. however based on the op's
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 /consol
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
>
Cygwin is v7.4.5.
There is v8.x code available in CVS, but you'll have 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 PROTE
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
-
27 matches
Mail list logo
