The disks you use also play a big part in the performance you get. If you
are going to have multiple simultaneous connections accessed the server,
I'd go with a good SCSI disk array. Maybe even RAID if it's going to be
under a high load.
At 07:49 PM 1/24/00, Peter Eisentraut wrote:
>This dep
You need this:
http://www.insightdist.com/psqlodbc/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Matthew Dormer
Sent: Monday, January 24, 2000 7:31 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] PostgreSQL running on Redhat 6.1 and VB6.0
Can you use
Ed Loehr wrote:
>
> Correction: this message happens when you 'commit' but without
> anything to commit.
>
> % destroydb test; createdb test; psql -d test -c "commit"
> NOTICE: EndTransactionBlock and not inprogress/abort state
> END
And it seems to be a harmless occurrence, **assuming** you
Correction: this message happens when you 'commit' but without
anything to commit.
% destroydb test; createdb test; psql -d test -c "commit"
NOTICE: EndTransactionBlock and not inprogress/abort state
END
Cheers,
Ed Loehr
Graeme Merrall wrote:
>
> > Not certain, but I think you get an error
Can you use Visual Basic 6.0 to Access a PostreSQL Database running on
Redhat 6.1?
Where would I find information on how to do this?
Matt
> Not certain, but I think you get an error message like that when you
> rollback at inappropriate (but harmless?) times, as in when you are
> not in a transaction or have nothing pending on the current
> transaction.
The transaction goes though OK so I don't think it's that. I'll take a
closer
This depends entirely(?) on what kinds of tables you use, especially their
size, and what kind of queries you want to do with it. 128MB RAM should be
fine for average applications, the hard disk size pretty much just limits
how much data you can store (and sort), and the processor factor is hard
t
[EMAIL PROTECTED]
On 2000-01-24, Yury Don mentioned:
> Hello All,
>
> Does anybody knows where to send bugreport for postgresql? I can't
> find this information on postgres site.
>
>
> Best regards,
> Yury ICQ 11831432
> mailto:[EMAIL PROTECTED]
>
>
>
>
>
>
--
Peter Eis
On 2000-01-24, Jose Soares mentioned:
> We need also aggregates for data type TIME
> MAX(time)
> MIN(time)
Thomas, do you think this could be done?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/
Not certain, but I think you get an error message like that when you
rollback at inappropriate (but harmless?) times, as in when you are
not in a transaction or have nothing pending on the current
transaction.
Cheers,
Ed Loehr
> Graeme Merrall wrote:
>
> Hi.
> I've been getting the following er
Hi.
I've been getting the following error in my scripts
using transactions to write to pg
NOTICE: EndTransactionBlock and not
inprogress/abort state
I didn't see much of it in the archives. I'm using
PHPLib and PHP3 which I suspect may be causing the problem, but I need a bit
more info.
Sir,
I encountered a problem when my postgres 6.5.3 stop running. I
attempted to run the postmaster but an error was displayed on my screen
which goes like this:
[root@hindang bin]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service: [FAILED]
C
On Mon, 24 Jan 2000, Ron King wrote:
> Hello Everyone,
>
> I want to build a prototype system under 32-bit Linux using
> a table that would be about 20GB with PostgreSQL. I looked
> through the archives and saw talk about a patch for PostgreSQL
> to fix a bug with tables > 2Gb. If the system wor
Hi all,
Using PostgreSQL 6.4 on BSD/OS 3.0
Is this a bug? Otherwise what am I doing wrong?
isfiji=> \q
moe:~ $ psql isfiji
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to qui
> Hello Everyone,
>
> I want to build a prototype system under 32-bit Linux using
> a table that would be about 20GB with PostgreSQL. I looked
> through the archives and saw talk about a patch for PostgreSQL
> to fix a bug with tables > 2Gb. If the system worked, I would
> like to migrate over to
Hello Everyone,
I want to build a prototype system under 32-bit Linux using
a table that would be about 20GB with PostgreSQL. I looked
through the archives and saw talk about a patch for PostgreSQL
to fix a bug with tables > 2Gb. If the system worked, I would
like to migrate over to a 64-bit Alph
> Tim McKenna wrote:
>
> When I run the 'postmaster -D /var/lib/pgsql' command the prompt never
> comes back unless I do 'ctrl Z'. Is that what its supposed to do?
> Other incantantions I used prior to that were from Lamar Owen's
> Version 1.5 Instal...
Without the -S, you need to put it in the
I would like to use the max row size to store data instead of using the
blob data type. From the FAQ, I understand each row must not cross 8k
boundaries so the actual data must stay below 5k.
1. Is 5k litteral, ie exactly 5120 bytes?
2. In this situation, would it be preferable to use the text d
Hi,
I'm use postgresql 6.5.3 on RedHat 6.1. To monitor the perfomance of
the system I use top. When I run VACUUM ANALYZE in psql monitor top
shows sometimes the state of postmaster as D. "man top" says that D in STAT
column is "uninterruptible sleep". Is this normal?
Best regards,
Alex
**
> Hi,
>
> How do I create a table from a 'select' statement?
> I tried the help from psql '\h create table',
> it does not explain how.
>
> I tried:
>
> create table blah2 as
> select pin from tbs_billing_record
> where date(start_time) between '01-JAN-2000' and '23-JAN-2000'
> order by pin;
S
Peter Eisentraut wrote:
> On 2000-01-21, Bruce Momjian mentioned:
>
> > > Is there a way to use the max aggregate on an oid field? When I try on
> > > 6.5.3, I get the following error message:
> > >
> > > test=> select max(uid) from user_base;
> > > ERROR: Unable to select an aggregate function
Hi,
I've been checking the archives and documentation for what the
system requirements are for a PostgreSQL database
It's to be used for a database with 8 users, and has MS-Access front-end
which causes app. 2 connections per user.
My idea was:
128Meg Ram
20 Gig HD
500 Mhz. Celeron
will
Chai,
Just miss out the order by, it has no meaning in a table definition.
ie
Create table blah2 as
select pin from tbs_billing_record
where date(start_time) between '01-JAN-2000' and '23-JAN-2000';
Dave
Hi,
How do I create a table from a 'select' statement?
I tried the help from psql '\h create table',
it does not explain how.
I tried:
create table blah2 as
select pin from tbs_billing_record
where date(start_time) between '01-JAN-2000' and '23-JAN-2000'
order by pin;
I received error saying:
helllo!
is there a way to set up UNICODE table for databases?
Or how to set launguages for certain databases or the whole server.
I have asked this before while i was away but the disk on server crashed
and i lost all my e-mails, before i had a chance to do anything.
Thanks for your answers!
Mitj
25 matches
Mail list logo
