>
>
> Would something like SQLite support the full functionality that we get
> from PostgreSQL: subqueries, transactions, views, triggers and stored
> procedures? MySQL does not (yes I know they are adding some or all of
> this but it isn't all there or proven to be reliable yet).
>
> I will
>
> For years I have struggled with desktop applications and data
> access/storage. Databases are very powerful tools but, other than MS
> Access, I have not seen any that are easily distributable bundled with
> a desktop application. Not having a personal database to bundle with
> my applicati
On Mon, 2006-03-27 at 20:22 -0500, Tom Lane wrote:
> Amadeus Zilfinski <[EMAIL PROTECTED]> writes:
> > I have a similar problem. Had FC4 and PostgresQL installed. Upgraded to
> > FC5, and want to use PostgresQL for a bugzilla backend. My problem is
> > the same as th
On Sat, 2006-03-25 at 23:26 +0200, Devrim GUNDUZ wrote:
> Hi,
>
> On Sat, 2006-03-25 at 20:46 +, Rick Ellis wrote:
> > I forgot to dump before I upgraded to Fedora Core 5 (Postgresql
> > 8.0.x to 8.1.x). Is there an easy way to bring up an 8.0.x server
> > long enough to dump the data?
>
> Do
,snipped.
> - SuSE 9.1
> - 2.6.6 kernel
> - Postgres 7.4.2
> - 300 TPS against DB containing 5-50GB data, no more than a dozen
> concurrent connections.
> - fsync (or not) and fdatasync
I remember a problem that was fixed in the 2.6.9 kernel concerning XFS
corruption (shutdowns I think were the
