/v8.3.11/win32/
ftp://developer.postgresql.org/pub/binary/v8.2.17/win32/
They will propogate to the main download pages in 24 hours.
That's odd ... wonder why v8.3 and v8.2 were overlooked ... but v8.4 was
moved?
Marc G. FournierHub.Org Hosting Solutions
to FreeBSD 6.x ... no patches required ...
--
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED]
Yahoo . yscrappy Skype: hub.orgICQ . 7615664
\n
invalid command \.
and other errors ... so I'm obviously missing something that is probably
obvious to everyone else ... am I dumping wrong? If I use '--inserts',
it, of course, works like a charm, its only when I try and use COPY ...
--
Marc G. Fournier Hub.Org Networking
[EMAIL PROTECTED] (Paul Lambert) writes:
Marc G. Fournier From: wrote:
This is one of those 'stupid questions I hate to ask' ... I've rechecked the
docs to make sure I haven't missed something stupid, and unless I'm blind,
I haven't ...
I'm trying to upgrade a database from 8.1 - 8.2
(CSV, TXT) directly to Postgres Tables.
Thanks Regards
M.AHRAM KHAN
-
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED]
Yahoo . yscrappy Skype: hub.org
select version(); template1
I believe 'psql --version' gives you version of psql, not the server itself,
while select version(); wil give you the server ...
-
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is this possible? I'm trying to debug a recurring error in MAIA, where its
trying to use 'rpad', but I can't find where ... if I turn on
'log_statement=all', there is just way too much data to weed through, so ...
-
Marc G. Fournier
The subject kinda says it all ... I know there are SNMP patches available
out there now, but without those ... ?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED]
Yahoo . yscrappy
On Sat, 10 Jun 2006, Joshua D. Drake wrote:
Marc G. Fournier wrote:
The subject kinda says it all ... I know there are SNMP patches available
out there now, but without those ... ?
We use Nagios to call shell scripts that perform specific requests to a
PostgreSQL server. Usually over SSH
) ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, 5 Apr 2006, Robin Iddon wrote:
Marc G. Fournier wrote:
I know ppl are using it to do replication, but has anyone documented what
is involved in doing so?
thanks ...
We use linux HA and linux DRBD (~RAID1 mirror between disks across a LAN) to
provide a similar replication mechanism
I know ppl are using it to do replication, but has anyone documented what
is involved in doing so?
thanks ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
be something else that I should be looking at ...
Thanks ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 6
It looks like moving to FreeBSD 6.x for some of our servers is biting me
in the butt ... they broke something with semaphores that used to work
with 4.x, so that you can't run two postmasters on port 5432 within two
seperate jails ... :(
On Sun, 2 Apr 2006, Marc G. Fournier wrote:
What
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
Secunia (not free)?
- August
---(end of broadcast)---
TIP 6: explain analyze is your friend
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ
@ pgfoundry are in problems but they do use postgresql
;)
An error occured in the logger. ERROR: could not extend relation
activity_log: No space left on device HINT: Check free disk space.
:(
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED
...
I could see some variations, but almost 4000x slower to *really* run the
query vs an explain analyze?
This is with 7.4.2 ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
above 10ms for that
query above when I do it from psql ...
Marc G. Fournier wrote:
'k, I've been wracking my brains over this today, and I'm either
mis-understanding what is being reported *or* its reporting wrong ...
According to syslog:
LOG: duration: 4107.987 ms statement: UPDATE
, see if they've maybe thrown in a
TRANSACTION wouldn't realizing/thinking of it :(
Thanks ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end
Is there a way of REVOKEing privileges on all tables in a database? I've
checked the REVOKE man page, and there doesn't appear to be, but I figured
I'd double check to make sure ...
---(end of broadcast)---
TIP 9: In versions below 8.0, the
On Mon, 8 Aug 2005, Joshua D. Drake wrote:
Marc G. Fournier wrote:
Is there a way of REVOKEing privileges on all tables in a database? I've
checked the REVOKE man page, and there doesn't appear to be, but I figured
I'd double check to make sure ...
No. This has actually been a requested
on Linux?
Thanks ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands
that
this is some sort of temp file that the NFS itself is creating, and is
safe to just delete, but am wondering if someone out there knows more
definitively ... ?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy
On Thu, 2 Jun 2005, Matthew D. Fuller wrote:
On Thu, Jun 02, 2005 at 10:19:38PM -0300 I heard the voice of
Marc G. Fournier, and lo! it spake thus:
Anyone actually dealing with a configuration using this for your
data drives? I'm looking for more details on what exactly they are
using
Do to moderator error (namely, mine), several hundred messages (spread
across all the lists) were just approved ...
Sorry for all the incoming junk :(
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy
modifications from the standard distribution ... or, at
least, that is how I remember it ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast
? :) Can you provide some more details? Hardware configuration, type
of query, operating system?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end
On Fri, 11 Feb 2005, Joshua D. Drake wrote:
[EMAIL PROTECTED] wrote:
Hi,
Does anyone know psql command for 'describe'.
explain?
I believe describe is mysql equivalent to our \d* commands ... no?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL
(postgres)
But, this is on a FreeBSD 4.x machine ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 1: subscribe
, comp.databases.postgresql.projects.slony1 was created
the other day on news.postgresql.org ... not sure if Jan has had a chance
to subscribe the appropriate address so that mail is gated to it, but the
group is there ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL
as the 'all-encompassing solution' for this, the chances of one
ever coming about that would be of a scope that would be acceptable to be
built-in is next to zero ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy
On Tue, 6 Jul 2004, Peter Eisentraut wrote:
Marc G. Fournier wrote:
Christopher is correct ... if there was such a thing as an 'end all,
be all' replication solution, there wouldn't be a half a dozen
different ones out there ...
Which ones are you thinking of in your count? I don't get anywhere
This is to be expected ... but, other then breaking the transaction
itself into smaller chunks, or staggering the scripts run times ... is
there something I'm overlooking to eliminate this? I could increase the
deadlock timeout, as an option as well ...
Marc G. Fournier Hub.Org Networking
On Mon, 5 Apr 2004, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
Now, the scripts are wrap'd in a BEGIN/END ... if a file fails to be
loaded, I want the whole thing to rollback ... the deadlock itself, I'm
presuming, is because two servers are trying to update the same
On Mon, 5 Apr 2004, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
D'oh ... just tested my assumption, it was wrong ... *sigh* okay, back
to the drawing board on the code ...
Can't you just change
foreach $company_id ( keys %traffic ) {
to
foreach $company_id ( sort
D'oh ... just tested my assumption, it was wrong ... *sigh* okay, back
to the drawing board on the code ...
On Mon, 5 Apr 2004, Marc G. Fournier wrote:
On Mon, 5 Apr 2004, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
Now, the scripts are wrap'd in a BEGIN/END
{$company_id}{$ip_id}} ) {
Matt
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
Are any maintained within the database that can be queried/viewed?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast
On Sun, 21 Mar 2004, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
Are any maintained within the database that can be queried/viewed?
http://www.postgresql.org/docs/7.4/static/monitoring-stats.html
Ack, had read it, but skim'd over it too fast :(
one question I do have
On Wed, 19 Nov 2003, Lucio wrote:
Hi,
I'am trying to create a demo cd (knoppix) with a jdbc application.
This application uses a static (read-only, no insert, modify or delete) 200MB
postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in ramdisk.
postmaster fails to start
What URL are you using? I just went to archives.postgresql.org, typed in
'mvcc' for a search and it came back in 10 seconds ...
On Fri, 14 Nov 2003, Nick Fankhauser wrote:
Can't help with the search engine, but the answer to your question is: psql
database name.
I'd recommend starting with
On Fri, 7 Nov 2003, Juan Miguel wrote:
Ok, the web works fine. The problem is my Zone Alarm Pro Firewall. I can
browse the most web pages, but when I connect to www.postgresql.org, the
download stops. Shuting down the firewall, the web is already accesible.
Any way of determining why?
works fine for me from here, and they are all on the same set of servers,
so it isn't network related ... browser?
On Wed, 5 Nov 2003, Juan Miguel wrote:
What happends with http://www.postgresql.org ?
When I try to connect to this URL, the download stops.
The only avalaible version of
okay, this falls under the stupid question, but want to make sure that
I'm right before doing it category ...
When we installed v7.2.4 on our server, multibyte wasn't compiled in ...
does enabling multibyte require a dump/reload if only new databases are
going to require it, and not existing
On Fri, 5 Sep 2003, Robert Treat wrote:
Personally I'd like to see effort go into getting fts.postgresql.org
back up and going; I've always had better results searching their.
As far as I know, the database side is ready for them, and Teodor has the
information, but I suspect that beta is
check the archive search now and let me know if you find it still doesn't
work ...
On Fri, 5 Sep 2003, Ang Chin Han wrote:
Marc G. Fournier wrote:
okay, first off ... what URL? I've been working on, and testing, archives
all week, and altho getting things down below a 2min search appears
go for it, point it at archives.postgresql.org though, since that is the
major part of the search engine
On Thu, 4 Sep 2003, scott.marlowe wrote:
On Tue, 2 Sep 2003, Marc G. Fournier wrote:
okay, first off ... what URL? I've been working on, and testing, archives
all week, and altho
k, try the search engine now ... I just found a 'missing index' on one of
the critical tables, and I'm getting more realistic speeds on search
results ...
On Thu, 4 Sep 2003, Marc G. Fournier wrote:
go for it, point it at archives.postgresql.org though, since that is the
major part
On Tue, 2 Sep 2003, Somasekhar Bangalore wrote:
Hi,
My installation went through fine but while setting up the ers_setup
ers_setup --masterserver=servername --masterdb=accounts \
--masteruser=someuser --masterpass=apasswd \
--slaveserver=otherserver --slavedb=erp \
okay, first off ... what URL? I've been working on, and testing, archives
all week, and altho getting things down below a 2min search appears to be
near impossible (anyone know something *better* then mnogosearch that will
handle 250k URLs and growing ... ? we tried ht/Dig before, and the
You need JDK 1.4.x ... or, at least, all our tests were done using it ...
On Fri, 29 Aug 2003, alexander v p wrote:
It was released couple of days ago. now i have a problem. i tried to
install to work with 7.3.4 on FreeBSD box ( cvsuped to stable) w/o luck.
i have problems with build:
any
In theory, the news2mail gateway is back in place ...
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Thu, 13 Mar 2003, Chad R. Larson wrote:
At 12:15 PM 3/13/2003 -0400, Marc G. Fournier wrote:
the database (Berkeley DB is used) backend for the majordomo2 lists isn't
the most stable, so we've been having periodic corruption problems where
we have to rebuild it
Does anyone else see
the database (Berkeley DB is used) backend for the majordomo2 lists isn't
the most stable, so we've been having periodic corruption problems where
we have to rebuild it ... the problem is that the rebuild process doesn't
seem to be aware of unsubscribe/set commands that were issued *after* the
what sort of errors?
On Mon, 10 Mar 2003, Xue-Feng Yang wrote:
--- Brickley Jeff-RA9607 [EMAIL PROTECTED]
wrote: How can I get off this email list.
unregister 'email address'
Came back with bogus errors!
__
On Tue, 28 Jan 2003, Will LaShell wrote:
Hrmm, this is kind of sad. rserv actually does work pretty well. We use
it in a production environment here at OFS on a medium size database
cluster.
I think you are the first person taht I've seen that has admit'd to using
it ... other then a few
On Tue, 28 Jan 2003, Will LaShell wrote:
The biggest one I've heard: documentation sucks
This truely is an issue, the documentation can be painful, however in
reality there is very little to do with it. Run the master / slave setup
add the tables, and run the replicate. I think perhaps
On Mon, 27 Jan 2003, Andrew Sullivan wrote:
On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
the eRServer is for free or not ?
Not, as far as I know. Its baby cousin is in contrib/rserv in the
source tree. I haven't tested it with 7.3, so I don't know whether
it works.
got it all back up tonight ...
On Thu, 14 Nov 2002, Gaetano Mendola wrote:
Hi all is almost one week that I'm not able to
retrieve message from the NG : unable to connect
--
Ciao
Gaetano
---(end of broadcast)---
TIP 3: if
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
On Thu, 21 Mar 2002, shreedhar wrote:
Hi All,
Where can i get souce of pgsqlODBC.
Regards,
Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph :
4475111 Email : [EMAIL PROTECTED]
Its news propogation, never has been an exact thing, and since not all
sites carry the hierarchies, it is even less so ... now, if there are
posts missing on news.postgresql.org itself, then I'd be worried :)
If anyone out there running a news server wishes to carry/propogate these
groups,
PostgreSQL Global Development Group
On Fri, 22 Feb 2002, Antony Stace wrote:
Hi
Can someone please tell me what the PGDG stands for in
postgresql-7.2-1PGDG.rpm
--
Cheers
Tony。
-
Try pointing your news reader at news.postgresql.org itself ... we just
fixed a permissions problem wiht the posts goign to the lists, so Google
and all them might get a better flow now too ...
On 11 Jan 2002, Jules Alberts wrote:
On 10 Jan 2002 17:37:25 -0800, Tony Reina [EMAIL PROTECTED]
to PHP3. You didn't say
what webserver you're using, but if it is apache then PHP3 runs
as a module. Also, PHP3 has persistent database connections. It
would mean a rewrite, though.
Or, to save the rewrite, look into mod_perl ...
Marc G. Fournier [EMAIL
file up
tomorrow...
Marc G. Fournier [EMAIL PROTECTED]
Systems Administrator @ hub.org
scrappy@{postgresql|isc}.org ICQ#7615664
66 matches
Mail list logo
