I've posted a short guide on how to get Movable Type 5, Postgres 9, and Tomcat
7.0 working together.
http://www.greenskagitvalley.com/blog/movable-type-5-with-tomcat-70x-and-postgres-90.html
-M@
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
Even though Movable Type 5 has dropped official support for Postgres it still
comes with the drivers in order for it to work. I've gotten it setup and
working with Postgres, but there is one problem that keeps me from being able
to use it. That issue I've explained over on the MT forums:
http
I've seen mention that it might be possible for MT5 to re-gain Postgres support
(they dropped it in version 5) through the use of plugins. Does anyone know of
such a thing and/or have an installation working themselves? Would greatly
appreciate any info you can share.
Thanks,
-M@
--
Sen
This may be a tad off topic, but thought a PG enthusiast might have
some insight on this. Apple Mail sits on top of Sqlite. I was
wondering if it would be possible to substitute Postgres as the
underlying database. I do know how to vacuum Sqlite to speed up
Mail, but with the massive amo
What are good settings for shared_buffers and max_connections with
the above software combo? Out of the box I'm getting the "Cannot
allocate memory" message upon doing a 'make check'.
Thanks,
-M@
---(end of broadcast)---
TIP 1: if posting/
With 8.2.4 is it possible to get Postgres to log incoming SQL
statements the same as they look when written? Instead of:
DEBUG: insert into foo (name) values ($1);
DETAIL: parameters: $1 = 'stan'
I'd like to see:
DEBUG: insert into foo (name) values ('stan');
This would be extremely helpful
Does Postgres have any native support for hierarchical data storage?
I'm familiar with the Adjacency List technique, but am trying to
determine whether or not Nested Sets would make sense for our
application or not. I understand that Nested Sets might be better
for high read applications,
I'm investigating the usage of a UUID primary key generator using
Hibernate and Postgres. The reason for using a UUID is that we will
have an application hosted at different sites in different
databases. We will need to aggregate the data back into a single
database from time to time and
Postgres 8.2.0 is logging statements with variables like $1, $2, etc.
and then on the next line saying:
DETAIL: parameters: $1 = '100', $2 = '100', $3 = '1003'
Is it possible to get statements logged with the parameters placed
into the actual query statement so that its more convenient to c
I am investigating data replication and failover ideas for a Java web
application. I would like the ability to have 2 or more Postgres
databases that are kept in synch, with the ability to loose all but 1
database and have the application still function. It seems that
Sequoia would work n
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Matthew Hixson wrote:
http://www.enterprisedb.com/news_events/press_releases/04_24_06.do
Was wondering if anyone had used that to import an Oracle .dmp
file and then export a Postgres 8.1 dump file for import into a
regular PostgreSQ
http://www.enterprisedb.com/news_events/press_releases/04_24_06.do
Was wondering if anyone had used that to import an Oracle .dmp file
and then export a Postgres 8.1 dump file for import into a regular
PostgreSQL database.
-M@
---(end of broadcast)-
Thanks, Michael. Don't know how I missed those.
-M@
On Jan 31, 2006, at 10:55 PM, Michael Fuhr wrote:
On Tue, Jan 31, 2006 at 10:37:47PM -0800, Matthew Hixson wrote:
I have a create function statement that works with Oracle 8i and I'm
trying to create this function in Postgres 8.
I have a create function statement that works with Oracle 8i and I'm
trying to create this function in Postgres 8.1.2.
CREATE OR REPLACE FUNCTION pr_user( p0 CHAR ) RETURN
Types.cursor_type IS
rs Types.cursor_type;
BEGIN
OPEN rs FOR
SELECT us.approval_type_code AS us_approval_type_code FROM
On Jan 27, 2006, at 4:10 PM, Thomas Kellerer wrote:
Matthew Hixson wrote on 28.01.2006 00:53:
I'm trying to get a large Java application which makes use of an
Oracle JDO layer to work with Postgres. Set aside for a moment
the discussion of whether or not that is going to work.
W
field_one
---
1
2
(2 rows)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Matthew Hixson
Sent: Friday, January 27, 2006 3:53 PM
To: Postgres General
Subject: [GENERAL] Postgres 8.1.2, Java, JDO, and case sensitivity
woes
I
I'm trying to get a large Java application which makes use of an
Oracle JDO layer to work with Postgres. Set aside for a moment the
discussion of whether or not that is going to work.
What I have found is that different parts of this application are
referring to a table in all uppercase an
On Dec 28, 2005, at 12:38 PM, Jim C. Nasby wrote:
http://archives.postgresql.org/pgsql-advocacy/2005-10/msg00311.php or
contrib/oracle are probably your best bet.
On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote:
What's the best way to import an Oracle database into Postgres?
goal?
Thanks,
-M@
On Dec 28, 2005, at 1:10 PM, David Fetter wrote:
On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote:
What's the best way to import an Oracle database into Postgres? I'm
using Oracle 8.1 and Postgres 8.1.1.
DBI-Link. http://pgfoundry.org/projects/db
What's the best way to import an Oracle database into Postgres? I'm
using Oracle 8.1 and Postgres 8.1.1.
Thanks,
-M@
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On May 20, 2005, at 3:00 PM, Tom Lane wrote:
Matthew Hixson <[EMAIL PROTECTED]> writes:
Just wondering if the Postgres hackers have done any performance
measurements on Postgres compiled with GCC 3.x against Postgres
compiled with GCC 4.0. I'm wondering whether or not the auto-
ve
Just wondering if the Postgres hackers have done any performance
measurements on Postgres compiled with GCC 3.x against Postgres
compiled with GCC 4.0. I'm wondering whether or not the auto-
vectorization stuff in 4.0 provides any performance improvements to
Postgres 8.0.x.
-M@
-
I also thought I saw quite a few more warnings this time than in the
past.
-M@
On May 19, 2005, at 11:05 AM, Jerry LeVan wrote:
For what it is worth...
I have 10.4.1 (Tiger) (archived and ) installed on my
old 933MHZ QuickSiver.
I also have Xcode 2.0 installed.
When I compiled 8.0.3 it seemed
On May 19, 2005, at 9:27 AM, Jeff Trout wrote:
On May 18, 2005, at 9:27 PM, Matthew Hixson wrote:
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype
(0) file: -lSystem is not an object file (not allowed in a library)
I had some issues with this error on a few other things on my
On May 19, 2005, at 5:42 AM, John DeSoi wrote:
On May 19, 2005, at 1:34 AM, Matthew Hixson wrote:
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype
(0) file: -lSystem is not an object file (not allowed in a library)
After upgrading to 10.4.1 and using Michael's paramete
On May 18, 2005, at 8:21 PM, Tom Lane wrote:
Michael Glaesemann <[EMAIL PROTECTED]> writes:
On May 19, 2005, at 10:27 AM, Matthew Hixson wrote:
8.0.3 does not build for me on Mac OS X 10.4. Anyone else seeing
this error, and will it be fixed in the next release?
I just built 8.0.3 on Ma
8.0.3 does not build for me on Mac OS X 10.4. Anyone else seeing
this error, and will it be fixed in the next release?
Thanks,
-M@
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Wendif-labels -fno-strict-aliasing -DFRONTEND -I. -I../../../src/
include -I../../../s
I had a bunch of tables that had v_ prepended to their names. I've
renamed all of the tables so that they don't have that prefix anymore
so that v_address is now addresses. The name of this table's sequence
is still v_addresses_address_id_seq. This is fine except for the fact
that I'm using
On Sep 23, 2004, at 7:19 PM, Alvaro Herrera wrote:
On Thu, Sep 23, 2004 at 07:02:26PM -0700, Matthew Hixson wrote:
I'm looking for a data modeler that can look at an existing database
schema and generate an ERD. A PDF of it would be nice. I'm using OS
X, but a Linux or Windows too
I'm looking for a data modeler that can look at an existing database
schema and generate an ERD. A PDF of it would be nice. I'm using OS
X, but a Linux or Windows tool would be acceptable too. I don't need
any other features than that right now. Just want to generate
something that new deve
On Sep 23, 2004, at 6:36 PM, Stephan Szabo wrote:
On Thu, 23 Sep 2004, Matthew Hixson wrote:
I have a categories table that contains a FK to another category in
the
same table, creating a hierarchy. At the very top is this row:
category_id | name | description | parent_id
I have a categories table that contains a FK to another category in the
same table, creating a hierarchy. At the very top is this row:
category_id | name | description | parent_id
-+--+-+---
1 | ROOT | The top level category
I am currently working on a Java web application. We are making use of
the JDBC driver for Postgres 7.4.1. Part of our application allows the
administrators to manage a large number of small images, most of them
not exceeding 5KB. There is about a gigabyte of these small files.
We're curren
I am currently working on a Java web application in which we are making
use of the JDBC driver for Postgres 7.4.1. Part of our application
allows the administrators to manage a large number of small images,
most of them not exceeding 5KB. There is about a gigabyte of these
small files. We're
On Wed, 25 Apr 2001, Ashley T. Howes wrote:
> I was wondering if PostgreSQL takes advantage of multiple CPUs when
> placed in a single Linux box. Or are multiple CPUs utilised as long
> as the Linux kernel is compiled to take advantage of them?
If you compile an SMP kernel Linux will balance
Hi Lonnie,
This is one of the reasons we are moving to an EJB server at work (we're
using Oracle there, but they wanted to accomplish the same thing you want
to do with Postgres). By exposing specialized interfaces to the db we
effectively limit the types of queries that can be run. That might
your philosophy.
On Wed, 18 Apr 2001, Mitch Vincent wrote:
> 7.1 is a release (the latest), 7.1rc4 is a *Release Candidate*.
>
> -Mitch
> Software development :
> You can have it cheap, fast or working. Choose two.
>
> - Original Message -
> From: "Matthew Hixson&
Which is the most recent version of Postgres, 7.1 or 7.1rc4 ?
Thanks,
-M@
--
There are more things in heaven and earth,
Horatio, than are dreamt of in your philosophy.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http:
edures?
>I
>know very little about them and need to learn everything I possibly can
>about
>them as soon as possible. I looked throught the Postgres docs and couldn't
>find anything that goes into them in depth.
> Thank you,
> -M@
--
Matthew Hixson - CIO
FroZenWave Communications
http://www.frozenwave.com
-M@
--
Matthew Hixson - CIO
FroZenWave Communications
http://www.frozenwave.com
Hello,
I'm searching for a PAM module that is capable of authenticating users
against information contained in a PostgreSQL database. Does something like
this exist arleady? This is to be used on a Linux system.
Any info would be greatly appreciated.
Thanks,
-M@
--
Matthew H
AM.
Thanks for any help,
-M@
--
Matthew Hixson - CIO Linux, n;
FroZenWave Communications the nouveau postmodern operating
http://www.frozenwave.com system for the masses
42 matches
Mail list logo
