Anyone knows of any good web hosting that support PostgreSQL?
Regards,
Thomas.
R D writes:
> You can inplement some option in the postmaster to
> trust to some user from localhost, for example:
> "postmaster --trust postgres &"
But the problem is that there's no way to know by what user a given
connection is actually initiated -- unless you use some authentication
mechani
agreed to all
I profusely appologize for all ruffled feathers
At 15:23 2000-06-02 -0500, al wrote:
>your request the everyone on this list stop using reply-ALL because YOU
>dislike getting multiple copies of a reply is vain and conceited to put
>it nicely
I suggest you re-read my messages. I never asked anyone to do anything. I
made *an offer* to people who
At 15:16 2000-06-02 -0500, al wrote:
>simply ignoring a problem wont make it go away
The above statement does not reflect the course of action I took.
Regardless, my solution is not intended to make the problem "go away". It
is intended to save me the time and effort it would take to:
1. Attemp
your request the everyone on this list stop using reply-ALL because YOU
dislike getting multiple copies of a reply is vain and conceited to put
it nicely
why should all of us need to install/edit/admin procmail to please you?
THAT is why I said you were on the wrong list
you need to be on the "I
> It has one advantage over the one you advocate (and which I tried): it works.
>
..^..?
So You run this list??
You say you tried to fix it??
otherwise you tried nothing
simply ignoring a problem wont make it go away
I advo
On Fri, Jun 02, 2000 at 02:26:58PM -0400, [EMAIL PROTECTED] wrote:
> > I know about Informix, but I heard Oracle was moving away from raw
> > devices, and the speed improvement was only a few percentage points.
>
> For Informix it's far more than a few percentage points; and then
> when you add
>
> > On Fri, 2 Jun 2000, Bruce Momjian wrote:
> >
> > > > > Most think that raw devices are a pain and offer little performance
> > > > > improvement and lots of portability and coding problems.
> > > >
> > > > I don't know how much it is a performance improvement (someone say
> > 10-20%),
> >
I get 100 MBps on 4 7200's, 2 on each SCSI-UW channel, all stipped into a
single /dev/md0 RAID-0 using 256-K chunks on RH62 and Intel Xeon 500 MHZ.
Fiber Channel drives are MUCH slower.
On Fri, 02 Jun 2000, Chris Albertson wrote:
> Ohgaki Yasuo wrote:
> >
> > I understand OID is signed integer
> On Fri, 2 Jun 2000, Bruce Momjian wrote:
>
> > > > Most think that raw devices are a pain and offer little performance
> > > > improvement and lots of portability and coding problems.
> > >
> > > I don't know how much it is a performance improvement (someone say
> 10-20%),
> > > but Bruce is p
Ohgaki Yasuo wrote:
>
> I understand OID is signed integer which go up to 2^31.
> Almost any case it would be sufficient. (It's sufficient for me, at least)
>
> What I really want to know is the same as original poster.
>
> > > 8. Can a database be spread over more than one disk drive?
Yes, b
On Fri, 2 Jun 2000, Bruce Momjian wrote:
> > > Most think that raw devices are a pain and offer little performance
> > > improvement and lots of portability and coding problems.
> >
> > I don't know how much it is a performance improvement (someone say
10-20%),
> > but Bruce is probably right, i
On Fri, 2 Jun 2000, Bruce Momjian wrote:
> > > Most think that raw devices are a pain and offer little performance
> > > improvement and lots of portability and coding problems.
> >
> > I don't know how much it is a performance improvement (someone say 10-20%),
> > but Bruce is probably right,
On Fri, 2 Jun 2000, Bruce Momjian wrote:
> > > [ Charset ISO-8859-1 unsupported, converting... ]
> > > > I understand OID is signed integer which go up to 2^31.
> > > > Almost any case it would be sufficient. (It's sufficient for me, at least)
> > > >
> > > > What I really want to know is the sa
At 11:17 2000-06-02 +0530, Pragati Sagar wrote:
>I already have a database created in mysql. But now I want to shift from
>mysql to postgresql but my problem is how to convert mysql database to
>postgresql. How will I import the tables from mysql? Please help me with
>this as I have not been able
> > Most think that raw devices are a pain and offer little performance
> > improvement and lots of portability and coding problems.
>
> I don't know how much it is a performance improvement (someone say 10-20%),
> but Bruce is probably right, it is a huge work and with dependence on
> hardwar
At 09:41 2000-06-02 -0500, al wrote:
>what a load!
>
>the solution is to FIX ONE LIST SERVER
>not RIG A THOUSAND PROCMAILS
>
>what a backwards solution
It has one advantage over the one you advocate (and which I tried): it works.
>when something is setup wrong you fix it
>dont adjust EVERYTHING
Pragati,
I am assuming that your webserver is running as user "nobody". If
that is the case, then you need to make sure that the user "nobody" can
access the table.
If your scripts only do selects on the table, then this command
would do the trick
GRANT SELECT on table1 to nobody
On Fri, Jun 02, 2000 at 04:35:29PM +0530, Pragati Sagar wrote:
> Hi!
> I connecting the postgreSQL database through the following code:
>
> $conn=pg_connect("","","","","");
> $index=pg_exec($conn,"select * from table1");
> ?>
>
> On execution of this code from the browser, following error app
My guess is that you have either duplicates in pg_database or pg_shadow,
but they have unique indexes so I don't know how that could happen.
> hi!
>
> i get double dumps for all tables, indices and acl's in my databases when
> trying to do a simple "pg_dump "!
>
> i'm using postgresql 7.0 on li
>
>
> Bruce Momjian schrieb:
>
> > I have added this to the PostgreSQL FAQ. Thanks.
>
> But you haven't done it yet, right ?
>
> I found nothing about the questions at
> ftp.postgresql.org/pub/v7.0.1/postgresql.7.0.1.docs.tar.gz.
That tarball is not updated, only the web site at this time.
> [ Charset ISO-8859-1 unsupported, converting... ]
> > I understand OID is signed integer which go up to 2^31.
> > Almost any case it would be sufficient. (It's sufficient for me, at least)
> >
> > What I really want to know is the same as original poster.
> >
> > > > 8. Can a database be spread
> > [ Charset ISO-8859-1 unsupported, converting... ]
> > > I understand OID is signed integer which go up to 2^31.
> > > Almost any case it would be sufficient. (It's sufficient for me, at least)
> > >
> > > What I really want to know is the same as original poster.
> > >
> > > > > 8. Can a data
Hi!
I connecting the postgreSQL database through the following code:
","","","","");
$index=pg_exec($conn,"select * from table1");
?>
On execution of this code from the browser, following error appears :
Warning: PostgresSQL query failed: ERROR: table1: Permission denied. in
/home/httpd/html/sc
Hello admin !
Where I get dll for postgresql 7.0 for WinNT (cygwin1.dll)
Thanks.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Hi!
I already have a database created in mysql. But now I want to shift from
mysql to postgresql but my problem is how to convert mysql database to
postgresql. How will I import the tables from mysql? Please help me with
this as I have not been able to find any diocumentaion on the net.
Thanks
A
what a load!
the solution is to FIX ONE LIST SERVER
not RIG A THOUSAND PROCMAILS
what a backwards solution
when something is setup wrong you fix it
dont adjust EVERYTHING ELSE
are you a MS programmer?
On Thu, 1 Jun 2000, [iso-8859-1] Ragnar Kjørstad wrote:
> On Tue, Jul 08, 2036 at 07:36:11AM +, LeSI wrote:
> > Jun 1 00:59:06 upa kernel: postmaster(11156): unaligned trap at
> > 00012013e320: 00011fff9d05 28 1
> >
> > how can i fix it?
>
> I'm on thin ice here, but I'm giving it
When loading a dumped database I get the ERROR message
psql:/tmp/savedump:574: ERROR: btree: index item size 3128 exceeds
maximum 2717
The database was dumped from postgresql 6.5 using that versions
pg_dumpall and was loaded into postgresql 7.0
Any ideas?
Bob
--
Bob Cregan [EMAIL PROTECTED]
Nobody seems to read on the [EMAIL PROTECTED] list...
Does anyone know anything about my question here ?
Nicolas Huillard
-Message d'origine-
De: Nicolas Huillard [SMTP:[EMAIL PROTECTED]]
Date: mardi 30 mai 2000 15:04
À: '[EMAIL PROTECTED]'
Objet: WAL status
Hello,
Searchin
If you don't have access to procmail and formail on your mail server, you
can ignore this message.
When I post to lists that don't add a Reply-To header to list messages,
repliers often use the Reply-All function of their mail client. This sends
one reply to the list and another to me. I dislike
Bruce Momjian schrieb:
> I have added this to the PostgreSQL FAQ. Thanks.
But you haven't done it yet, right ?
I found nothing about the questions at
ftp.postgresql.org/pub/v7.0.1/postgresql.7.0.1.docs.tar.gz.
Norbert
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Chris Albertson writes:
>
> > > > 2.Why the authentication system is not
> integrated in
> > > > the system databases of pgSQL,like in MySQL
> for
> > > > example?
> > >
> > > Because there's a bootstrapping problem: You
> would have to connect
hi!
i get double dumps for all tables, indices and acl's in my databases when
trying to do a simple "pg_dump "!
i'm using postgresql 7.0 on linux (kernel 2.2.14, almost all libraries out
of slackware 7).
is there any known bug?
thanks!
gunny
ps: please include me in your replies, since i'm
Peter Eisentraut wrote:
> Wallingford, Ted writes:
>
> > I am using 6.3 in this case.
>
> I'm sorry but that is pre-historic era around here and no one really
> remembers what the problems might have been back then (other than that
> they were surely plenty). Upgrading might be your best bet on al
36 matches
Mail list logo
