On Sun, Jan 22, 2006 at 02:25:33PM -0500, Tom Lane wrote:
I seem to recall that someone had come up with a datatype that would
store numbers with units attached, which seems like what you want here.
Check the PG list archives, and/or poke around on pgfoundry and gborg.
Hmm, I only just noticed
Title: RE: [GENERAL] logging connections
i did the above, however still no looging is being done.
for eg if i have a c++ program where i establish a connection to postgres and does some activity.
the postgres log should log the above connection to postgres when i run the program.
Hi,
my cron job which is dumping the databse fails this night. I got:
pg_dump: ERROR: invalid memory alloc request size 18446744073709551614
pg_dump: SQL command to dump the contents of table spieletipps failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory
Title: RE: [GENERAL] logging connections
please clarify the following:
log_destination (string)
PostgreSQL supports several methods for logging server messages, including stderr and syslog. On Windows, eventlog is also supported. Set this option to a list of desired log destinations
Hopefully your problem is solved by now; but if not, here's the link:
do read the README expanded at the end of the file-list:
http://www.postgresql.org/ftp/binary/v8.1.2/win32/
I could give you a long lecture on how to look for the things on your
own a little bit before pestering these mailing
Hi,
I need create SP that returns cursos so that I can work with them.
I have many SQLs used for search records in database, then I will make
SP to return the results.
The example that I'm trying is:
CREATE OR REPLACE FUNCTION fun_compras_calculado() RETURNS SETOF
tipo_compras_calculado AS '
I discovered a problem in DBMirror.pl, performance wise.
pending.c stores data in a way
very similar to the PgSQL input \ escaped format.
When the field is of type bytea, and the source of data is binary, then
this produces 2 additional backslashes for every unprintable
char.
The performance
Hi,
we are running a very popular german website[*] which has grown over the years
since 1995. We manage between 10 and 20 millions pageviews a month. We are a
small company and myself is responsible for programming, DBA, system
administration and hardware. I am a self-educated person since
The Whitebeam implementation of DBMirror.pl :
http://www.whitebeam.org/library/guide/TechNotes/replicate.rhtm
is a complete re-write in 'C' which avoids a lot of the text processing, and what text processing is required is done using a state machine rather
than repeated regular
am 23.01.2006, um 11:38:28 +0100 mailte Janning Vygen folgendes:
I would like to talk to some professional Postgresql DBA personally
(preferred
in german language). Of course we will pay for it. I don't want to talk to
sells personal, i want to talk to someone who really knows and has lots
On Jan 23, 2006, at 3:27 AM, Marcos wrote:
I need create SP that returns cursos so that I can work with them.
I have many SQLs used for search records in database, then I will make
SP to return the results.
The example that I'm trying is:
I did not notice any obvious errors. It would help
Peter,
It is much more convinient for you to make a test,
(just change the last function in DBmirror.pl), than for me
(grab whitebeam, compile for FreeBSD, etc...)
Of course you would need to use the original .conf format
than the one you are using now.
It would be interesting to see some
OK. Thanks for clarification.
- Original Message -
From: Doug McNaught [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org; Tony Caduto
[EMAIL PROTECTED]
Sent: Sunday, January 22, 2006 2:39 PM
Subject: Re: [GENERAL] numeric data type?
Zlatko Matić
I have a (only vaguely) related question about NUMERICs. I'm using
someone else's schema to copy data from their DB into mine. They use
NUMERIC quite a bit, with scale 0, where I would use one of the integer
types. My question is whether joining and matching on NUMERIC is
likely to be
On Mon, Jan 23, 2006 at 09:48:52AM -0500, John D. Burger wrote:
I have a (only vaguely) related question about NUMERICs. I'm using
someone else's schema to copy data from their DB into mine. They use
NUMERIC quite a bit, with scale 0, where I would use one of the integer
types. My
Hi John
Thanks for response.
In other words, what does
select * from fun_compras_calculado();
return and if it is not an error, why is it wrong?
My problem is in CREATE the function, see:
[EMAIL PROTECTED] psql teste -U teste teste.sql
ERRO: tipo tipo_compras_calculado não existe
In
On Sat, 2006-01-21 at 07:09, Sander Steffann wrote:
Hi,
I would suppliment this with just saying that your controller card is
your performance,
the only cards I've seen score well on linux, and people have
expressed on this list for SCSI are the LSI card, for SATA, LSI, 3ware
(now
Janning Vygen [EMAIL PROTECTED] writes:
pg_dump: ERROR: invalid memory alloc request size 18446744073709551614
pg_dump: SQL command to dump the contents of table spieletipps failed:
PQendcopy() failed.
This looks more like a corrupt-data problem than anything else. Have
you tried the usual
On Jan 23, 2006, at 8:34 AM, Marcos wrote:
ERROR: type tipo_compras_calculado not exists.
You have a set returning function (RETURNS setof
tipo_compras_calculado), so this means you need to declare this type.
So you should have a CREATE TYPE statement somewhere which defines
the fields
Dear pgsql users,
I have a problem, which is quite hard to solve it in Perl (for me, of
course). I have to tables, which looks like
First Table:
1|001|002|003
2|006|04|002
Second Table:
001|text1|text2|text3
002|text6|text1|text2
Now I would like to concatenate this two tables into new
Is there such a thing as a translator/proxy that can pretend to be a
Microsoft SQL server and proxy all the commands to a PostgreSQL server,
and the results back again? Obviously the purpose of it would be to
allow an application written for MSSQL Server to work with PostgreSQL
without
[EMAIL PROTECTED] writes:
Hi,
If you have two tables, each with a column called keys and a column
called values, and they are both incomplete, such as:
table 1:
keys | values
-+--
1| (null)
2| two
3| (null)
table 2:
keys | values
-+-
1
Hello All,
I have installed Tsearch-Module for full text indexing .But when I search text
using gist(idxFTI) index on table I also found
all data which have same accent. Example
1.If I try search for MANI word it also search for MANY word.
2.If I try search for ANDY word it also search for
Hi,
First, apologies if my question is a bit off-course. Please feel free to
direct me to a different mailing list if not appropriate.
I'm currently trying to embed Senna full text search engine
(http://qwik.jp/senna/) into postgres. I'm trying to achieve this by
using triggers (implemented in
At 10:01 AM 1/23/2006 -0600, Scott Marlowe wrote:
I'm not sure if it's Dell's BIOS on the mobos, or something with the LSI
cards, but the performance was substandard.
So if you're working somewhere that you simply have to use Dell (not
uncommon), at least make sure you get the LSI based RAID
Am Montag, 23. Januar 2006 17:05 schrieb Tom Lane:
Janning Vygen [EMAIL PROTECTED] writes:
pg_dump: ERROR: invalid memory alloc request size 18446744073709551614
pg_dump: SQL command to dump the contents of table spieletipps failed:
PQendcopy() failed.
This looks more like a corrupt-data
Janning Vygen [EMAIL PROTECTED] writes:
I shouldn't call gdb while my database is up and running, don't i?
Sure you can. Especially against a core dump --- that mode doesn't have
anything to do with the running processes.
$ delete from spieletipps where ctid = '(3397,49)';
Server beendete
--- James Harper [EMAIL PROTECTED] wrote:
Is there such a thing as a translator/proxy that can pretend to be a
Microsoft SQL server and proxy all the commands to a PostgreSQL
server,
and the results back again? Obviously the purpose of it would be to
allow an application written for MSSQL
On Sun, 2006-01-22 at 18:46, James Harper wrote:
Is there such a thing as a translator/proxy that can pretend to be a
Microsoft SQL server and proxy all the commands to a PostgreSQL server,
and the results back again? Obviously the purpose of it would be to
allow an application written for
Achilleus Mantzios wrote:
Peter,
It is much more convinient for you to make a test,
(just change the last function in DBmirror.pl), than for me
(grab whitebeam, compile for FreeBSD, etc...)
Of course you would need to use the original .conf format
than the one you are using now.
It would be
I figure this would be a good place to ask. I want to build / buy a
new linux postgres box. I was wondering if anyone on this list had
some experience with this they'd like to share. I'm thinking
somewhere in the $7k - 15k range. The post important things are
write speed to the disk and
On Jan 21, 2006, at 8:09 AM, Sander Steffann wrote:
Dell has used (and rebranded) Adaptec and LSI controllers for their
PERC series, and I agree that the Adaptec controllers perform
badly. As far as I know the LSI based controllers are quite good
(and some come with 256MB battery backed
Hi,
Are indexes on VARCHAR columns used with the LIKE operator, and if so,
how efficiently are they used?
I can imagine that using indexes can be easy with the starting literal
characters up to the first percent sign such as in:
LIKE 'ZOE%QQWE%'
But, after the first % sign, things can get
Janning Vygen [EMAIL PROTECTED] writes:
Ok, i got the reffilnode from pg_class and compiled pg_filedump. result of
./pg_filedump -i -f -R 3397 /home/postgres8/data/base/12934120/12934361
filedump.txt is attached
OK, what's the schema of this table exactly? It looks like there are
a couple
Ok then, the size of the postgres data directory is about 1 GB. The
OS will be a version of linux with a 2.6 kernel. 100 GB of total
storage would be plenty. The load load would probably be around
2k-3k transactions / minute. I plan on doing a lot of research on my
own I am just
On Jan 23, 2006, at 11:13 AM, Rick Gigger wrote:
I figure this would be a good place to ask. I want to build / buy a
new linux postgres box. I was wondering if anyone on this list had
some experience with this they'd like to share. I'm thinking
somewhere in the $7k - 15k range. The
Am Montag, 23. Januar 2006 20:30 schrieb Tom Lane:
Janning Vygen [EMAIL PROTECTED] writes:
Ok, i got the reffilnode from pg_class and compiled pg_filedump. result
of ./pg_filedump -i -f -R 3397
/home/postgres8/data/base/12934120/12934361 filedump.txt is attached
OK, what's the schema of
What about upping ulimt(3) via ulimit(1) in builtin(1) -- assuming you're
running Bash.
~BAS
On Mon, 9 Jan 2006, Ari Kahn wrote:
I'm doing a query that really should be too taxing. But when I execute it I
get the following error(s):
psql(18967) malloc: *** vm_allocate(size=8421376)
Hi
I have fedora core4 and i've installed the pgadmin III RPM when i try to
run the pgadmin i get a 'Speicherzugriffsfehler' which means something
like memory access error.
can someone help me please
thanks martin
---(end of broadcast)---
TIP
It is with great pleasure that the Bricolage development team
announces
the release of Bricolage 1.10. The culmination of over 19 months of
development, version 1.10 represents a significant advance for the
celebrated open-source content management and publishing system.
Here
Janning Vygen [EMAIL PROTECTED] writes:
OK, what's the schema of this table exactly?
...
Regeln:
cache_stip_delete AS
ON DELETE TO spieletipps DO UPDATE tsptcache SET tc_cache = -2
FROM tippspieltage2spiele tspt2sp, spiele sp
WHERE tsptcache.tr_kurzname = old.tr_kurzname AND
Rick Gigger wrote:
I figure this would be a good place to ask. I want to build / buy a
new linux postgres box. I was wondering if anyone on this list had
some experience with this they'd like to share. I'm thinking
somewhere in the $7k - 15k range. The post important things are
write
Thanks! That's just the sort of info I am looking for.
I am definitely going with the fastest scsi drives I can get.
Probably a 6 or 8 disk system. Is there a huge jump between using 4
and 6 drives, or 6 and 8 drives?
On Jan 23, 2006, at 12:42 PM, Steve Atkins wrote:
On Jan 23, 2006,
TOM! Ich will ein Kind von Dir!!
(it means 'something like': thank you so much. you just saved my life!)
Am Montag, 23. Januar 2006 21:16 schrieb Tom Lane:
Janning Vygen [EMAIL PROTECTED] writes:
OK, what's the schema of this table exactly?
...
Regeln:
cache_stip_delete AS
ON
Janning Vygen [EMAIL PROTECTED] writes:
Hmm ... the one part of that that jumps out at me is plperl. We already
know that plperl can screw up the locale settings; I wonder whether
there are other bugs. Anyway, if you are using plperl I *strongly*
recommend updating to the latest PG release
Am Montag, 23. Januar 2006 21:57 schrieb Tom Lane:
Janning Vygen [EMAIL PROTECTED] writes:
ok, shouldn't i upgrade to 8.1 instead of 8.0.6 if i can?
Up to you --- you have more risk of compatibility issues if you do that,
whereas within-branch updates are supposed to be painless. Depends
Janning Vygen [EMAIL PROTECTED] writes:
one more question: You mentioned standard disk and memory checks. Can you
point to some link where i can find more about it or which software do you
mean? I guess i have to start looking at it.
The stuff I've heard recommended is memtest86 for memory
unsubscribe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
I second Tom:
badblocks and memtest86 are what I use and works great on all kinds of
hardware. You don't even need a specific OS for memtest86 because you
can make a bootable floppy and test any old piece of hardware it recognizes.
Terry
--
Terry Fielder
[EMAIL PROTECTED]
Associate
I've successfully installed Postgres 8.1.2 on WS 2003 R2 on
a Lenovo (IBM) ThinkPad. I used the default installation options and
everything seems peachy keen for a single user (using localhost).
However, when we started performance testing
Postgres(vs. MySQL) using a 3rd party tool (I
On Jan 22, 2006, at 3:10 , Tom Lane wrote:
That's odd --- AFAIR I've never had trouble building bison on my OS X
laptop. What happens when you try?
I neglected to take any notes. I remember it was complaining about
muscle something-or-other during make.
One workaround would be to check
I need to load CSV files that have quotes in data fields that I want to
map to NULLs in the destination table. So if I see ...,,... that needs
to be mapped to a NULL (in an INTEGER field in this particular case).
Are there any COPY command options that can do that? It seems that PgSQL
COPY expects
I was doing a search on Google and found this link on Navicat's web page
http://pgsql.navicat.com/PG_Lightning_Admin/index.php
I am kind of ticked off that they are hijacking my product name this way.
This isn't really postgresal related but I was just wondering what
others thought about
George Pavlov wrote:
I need to load CSV files that have quotes in data fields that I want to
map to NULLs in the destination table. So if I see ...,,... that needs
to be mapped to a NULL (in an INTEGER field in this particular case).
Are there any COPY command options that can do that? It
Tony Caduto wrote:
I was doing a search on Google and found this link on Navicat's web page
http://pgsql.navicat.com/PG_Lightning_Admin/index.php
I am kind of ticked off that they are hijacking my product name this way.
This isn't really postgresal related but I was just wondering what
Tony Caduto wrote:
I was doing a search on Google and found this link on Navicat's web page
http://pgsql.navicat.com/PG_Lightning_Admin/index.php
I am kind of ticked off that they are hijacking my product name this way.
This isn't really postgresal related but I was just wondering what
Bruce Momjian wrote:
Tony Caduto wrote:
I was doing a search on Google and found this link on Navicat's web page
http://pgsql.navicat.com/PG_Lightning_Admin/index.php
I am kind of ticked off that they are hijacking my product name this way.
This isn't really postgresal related but I was
Joshua D. Drake wrote:
Bruce Momjian wrote:
Tony Caduto wrote:
I was doing a search on Google and found this link on Navicat's web page
http://pgsql.navicat.com/PG_Lightning_Admin/index.php
I am kind of ticked off that they are hijacking my product name this way.
This isn't
I need to load CSV files that have quotes in data fields
that I want to
map to NULLs in the destination table. So if I see
...,,... that needs
to be mapped to a NULL (in an INTEGER field in this
particular case).
Are there any COPY command options that can do that? It
seems
Joshua D. Drake wrote:
Tony Caduto wrote:
I would call it fairly shady. I am guessing that by doing so they are
getting placement within search
engines or something.
Hi Joshua,
Yep, that's the part that I don't like.
Using Postgresql in there is one thing as it's good because you have to
Tony.
I was doing a search on Google and found this link on Navicat's web page
http://pgsql.navicat.com/PG_Lightning_Admin/index.php
I am kind of ticked off that they are hijacking my product name this way.
Well, technically they aren't hijacking your product name, they are
hijacking
Bruce Momjian wrote:
Oh, I thought they were shipping PG lighening admin too. The URL no
longer works so I wonder if they thought better of the practice.
No, PG Lightning Admin is my product name, and I think they are doing
something with a link to my page in their page because my page is
Tony.
Maybe if you take the high road you could work something out that would
help you both?
Well, since the page is gone already I'd say both parties seem to be
playing fair.
Good deal!
brew
==
they have the same kind of page setup for pg Admin:
http://pgsql.navicat.com/PG_Admin/index.php
this one renders...
both pages seem to tell robots not to cache them, so can't view a cached
view on google.
---(end of broadcast)---
TIP 4: Have you
[EMAIL PROTECTED] wrote:
Well, since the page is gone already I'd say both parties seem to be
playing fair.
Good deal!
brew
I don't know about that, the link is still there, it just gives a error
of No input file specified, which just indicates the index.php in
I don't know about that, the link is still there, it just gives a
error of No input file specified, which just indicates the index.php
in http://pgsql.navicat.com/PG_Lightning_Admin/ is gone or having a
problem.
I asked them nicely to remove it within 24 hours, so we shall see.
Well the
George Pavlov wrote:
they have the same kind of page setup for pg Admin:
http://pgsql.navicat.com/PG_Admin/index.php
this one renders...
both pages seem to tell robots not to cache them, so can't view a cached
view on google.
At least PG Admin is free software and doing that is not really
the blue links at the top (as it states in the top right) are sponsor'd
links ... they pay for those to be there, and, I'd imagine, pay quite
heavily :(
On Mon, 23 Jan 2006, Tony Caduto wrote:
George Pavlov wrote:
they have the same kind of page setup for pg Admin:
Title: RE: [GENERAL] FATAL: terminating connection due to administrator command
The exact message i saw is this:
LOG: received fast shutdown request
LOG: aborting any active transactions
FATAL: terminating connection due to administrator command
so does this mean that someone is trying to
Tom Lane [EMAIL PROTECTED] writes:
Janning Vygen [EMAIL PROTECTED] writes:
one more question: You mentioned standard disk and memory checks. Can you
point to some link where i can find more about it or which software do you
mean? I guess i have to start looking at it.
The stuff I've
70 matches
Mail list logo
