Hello,
i have one postgresql server (7.0) where several users access.
Is there any way to improve performance for:
i) accesses of different users at different dbs
ii) accesses of different users at the same db
Thanks.
Hello,
i have one postgresql server (7.0) where several users access.
Is there any way to improve performance for:
i) accesses of different users at different dbs
ii) accesses of different users at the same db
Thanks.
I have a database in production under 6.5 and i need to use the to_date and
to_char function.
I planned to migrate to postgres 7.0 later but i need a compatibility from now
for my projects.
Where do i find the postgres65.sql to install this functions under postgres 65 ?
thanks,
oliver
On Wed, Feb 28, 2001 at 10:28:11AM +0100, ochapiteau wrote:
I have a database in production under 6.5 and i need to use the to_date and
to_char function.
I planned to migrate to postgres 7.0 later but i need a compatibility from now
for my projects.
Where do i find the postgres65.sql to
so i've got my data recovered (thanks to oliver) and now
i wanna back it up with a pg_dumpall...
instead, i get 'failed sanity check, type with oid 779927 was no
found' in the oddest places...
% pg_dumpall
[snip!!]
CREATE FUNCTION "get_disid" (int4,varchar ) RETURNS int4 AS '
SELECT
But i've seen in a faq about the postgres65.sql file which add this
functions for postgres 6.5 (and is replaced by an other one in tcl) ?
I can't find this file (not in postgres 6 7 src).
I'm i wrong ?
what's postges65.sql ?
Le mer, 28 fév 2001, vous avez écrit :
On Wed, Feb 28, 2001 at
will trillich wrote:
On Wed, Feb 28, 2001 at 06:52:01AM +, Oliver Elphick wrote:
A pity the dump file got clobbered.
indeed!
I suspect the dump from 6.5 was
in a form that 7.0 rejected - you had those two failed creates in the
log.
the problem was apparently
On Wed, Feb 28, 2001 at 09:31:35AM +, Oliver Elphick wrote:
will trillich wrote:
NOW if i can just get PERL to work with DBD::Pg again, i'd
be done! this is gonna be fun to track down now that my data
is back...
Can't load
Can I create object and methods with postgreSQL.
And how?
Thank in advance,
Renaud THONNART
From: "will trillich" [EMAIL PROTECTED]
so i've got my data recovered (thanks to oliver) and now
i wanna back it up with a pg_dumpall...
instead, i get 'failed sanity check, type with oid 779927 was no
found' in the oddest places...
% pg_dumpall
[snip!!]
CREATE FUNCTION "get_disid"
From: "Renaud Tthonnart" [EMAIL PROTECTED]
Can I create object and methods with postgreSQL.
And how?
Thank in advance,
Renaud THONNART
You can define your own types with functions and operators - see chapter 13
of the programmers manual.
- Richard Huxton
"Binary RPMs are currently available for i386 and PowerPC.
Distributions supported are RedHat 6.x, RedHat 7.0, TurboLinux 6.0.4,
SuSE 7.0, SuSE 6.4, Caldera OpenLinux eServer 2.3 (NOT eDesktop 2.4 --
there are differences!), and LinuxPPC-2000. Source RPMs for
RedHat-style systems are in SRPMs,
Tom Lane [EMAIL PROTECTED] writes:
John Madden [EMAIL PROTECTED] writes:
I guess the subject says it all -- what's the easiest way to do a vacuum
(say, nightly) if you're not allowing "trust" from local unix sockets?
(Counting out, of course, putting a password in any files...)
Doug McNaught [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
Perhaps do it across a local TCP connection and use ident to verify?
And if you think this is somehow more secure than trusting Unix
sockets, I have a bridge to sell you... ;)
Why? It's your own ident daemon you're
I've tried fruitlessly to install cygwin1.1.8 work with postgresql7.03
Has any body out there done it?
Where can I get the latest postgresql7.1?
Thank you
try http://osx.hyperjeff.net/Apps
several database ports for osx, including postgresql, are available by
hyperlink.
james
On Wed, 28 Feb 2001, liam wrote:
Has anyone tried successfully or unsuccessfully to install postgresql
under the new Mac OS X mach/netBSD kernel Darwin?
--
Later . .
I tried at one point though I don't know the cygwin version.
I didn't work; said c compiler cannot produce
executeable
On Wed, Feb 28, 2001 at 10:43:54PM -0500, Jeff wrote:
I've tried fruitlessly to install cygwin1.1.8 work with postgresql7.03
Has any body out there done it?
Where can I
On Wed, 28 Feb 2001 14:54, Joseph Shraibman wrote:
About what? Your book covered all the basics.
Bruce Momjian wrote:
As many of you know, I wrote a PostgreSQL book last year.
If you were to repeat the exercise would you use the LyX / LaTeX
combination again?
De you feel able to share
On Thu, 01 Mar 2001 18:11, [EMAIL PROTECTED] wrote:
try http://osx.hyperjeff.net/Apps
several database ports for osx, including postgresql, are available by
hyperlink.
http://www.geeklair.net/downloads/postgresql-7.1b-02122001-macosx.tar.gz
A 30.1M download!!!
What's in it?
Has anybody
hi. i've got a scenario i'd like to run past the pg/sql
experts...
short version: how can i have a trigger after insert, take the
fresh data and propagate changes to other tables in the database?
long version:
i'm using postgresql 7.0.3 on debian/potato -- and in trying to
implement a feedback
On Tue, Feb 27, 2001 at 10:09:49AM +0100, Jose Manuel Lorenzo Lopez wrote:
Aristide Aragon schrieb:
On Mon, Feb 26, 2001 at 01:53:18PM -0500, Belcher, Jim wrote:
Hello
OK, I got the problem sorted out. The error message I received was "Error Message:
FATAL 1: Database "mydb" does not exist
Hello,
I would like to bring subj to your attention again.
The problem is the following:
I need to have cursor opened for a long time.
I declare a cursor on the table of approx. 1 million rows.
And start fetching data by 1000 rows at each fetch.
Data processing can take quite a long time (3-4
Am Mittwoch, 28. Februar 2001 10:43 schrieb will trillich:
so i've got my data recovered (thanks to oliver) and now
i wanna back it up with a pg_dumpall...
instead, i get 'failed sanity check, type with oid 779927 was no
found' in the oddest places...
I'm just guessing, but it is possible
Hello all, hello Bruce,
first of all I want to say, that Bruces Book was very well done in my
opinion!
To answer the question, I already began writing a book about PostgreSQL for
Addison Wesley in Germany. It will be released in autumn this year in german
language. Perhaps it could be
24 matches
Mail list logo