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
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
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:
http://pgsql.navicat.
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 h
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 c
[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
http://pgsql.navicat.com/P
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
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
==
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.
> 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
hijacki
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
> > 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?
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 wa
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 ju
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
others
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
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
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 this.
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 expect
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'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
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 Directo
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
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 memo
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. Dep
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
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_delet
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,
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 s
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_kurz
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
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 1:
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) faile
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
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 post
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 looking
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 co
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
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 ca
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
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 int
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
--- 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
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 beendet
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
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 co
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 C)
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 ANDI
[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
> -
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 modification
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 table:
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 field
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
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
>
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 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 que
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 slower
OK. Thanks for clarification.
- Original Message -
From: "Doug McNaught" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>
Cc: ; "Tony Caduto"
<[EMAIL PROTECTED]>
Sent: Sunday, January 22, 2006 2:39 PM
Subject: Re: [GENERAL] numeric data type?
Zlatko Matić <[EMAIL PROTECTED
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 number
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
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 l
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 expressio
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 th
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,
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 '
DE
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 separat
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 l
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 al
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.
similarl
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 notic
70 matches
Mail list logo
