Hi all
The FAQ says that win2k is supported, but the last buildfarm activity
for win2k was ages ago, and we've had a post recently saying it doesn't
work.
Buildfarm members for win2k:
bandicoot - 1297 days ago
bee - 1745 days ago
trout - 1122 days ago
Should win2k be declared dead and dro
Can anyone ta;lk to me about the PL/TCL implementation of the Unkown
function?
The docs are nice, but more of a tease.
http://www.postgresql.org/docs/8.3/static/pltcl-unknown.html
I have to make this work on Windows and Linux. I'm the Windows guy, I'll
have to explain this to the Linux guy!
On 04/10/10 13:58, Craig Ringer wrote:
> Hi all
>
> The FAQ says that win2k is supported, but the last buildfarm activity
> for win2k was ages ago, and we've had a post recently saying it doesn't
> work.
Ah, never mind. The Windows-specific bits of the FAQ were badly out of
date in other places (
I wish I could see those hanging queries, what SQL do they try to execute:
pref=> select * from pg_stat_activity;
datid | datname | procpid | usesysid | usename |current_query
| query_start | backend_start | client_addr |
client_port
---+-+-+
Dear Farber,
Is there anything that stops you from upgrading to a more respectable
release number?
Eg 9.0 or at least latest 8.4.X
Regds
Rajesh Kumar Mallah.
While compiling PostgreSQL-9.0.0 on HP-UX/ia64 (B.11.23) gmake breaks up with
the next errors:
.
gmake -C libpq all
gmake[3]: Entering directory
`/anva/compile-postgres/psqlsource/postgresql-9.0.0/src/backend/libpq'
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-state
Hello again,
ouch, I have these postmaster's spinning up again -
even though I've disabled the cronjob and rebooted:
top - 11:42:31 up 1:22, 2 users, load average: 9.15, 7.59, 5.03
Tasks: 135 total, 10 running, 125 sleeping, 0 stopped, 0 zombie
Cpu0 : 31.7%us, 0.5%sy, 0.0%ni, 67.4%id,
Alexander Farber skrev 2010-10-04 11.48:
I wish I could see those hanging queries, what SQL do they try to execute:
To see the query you need to enable stats_command_string in your
postgresql.conf. See:
http://www.postgresql.org/docs/8.1/interactive/runtime-config-statistics.html
You migh
Hi,
I want to change the way PostgreSQL splits text into tokens, for example:
plainto_tsquery("v-74") should split it up as "v" & "74" instead of "v" &
"-74".
Another example:
select to_tsvector('NL83-V-74-001-001')'-001':5,6 '74':4 'nl83':2
'nl83-v':1 'v':3
Searching for 'v-71' does not find
Derk Jan Horstman writes:
> While compiling PostgreSQL-9.0.0 on HP-UX/ia64 (B.11.23) gmake breaks up with
> the next errors:
> ip.c:654: error: storage size of 'lifc' isn't known
> ip.c:656: error: storage size of 'lmask' isn't known
> ip.c:692: error: invalid application of 'sizeof' to incomplet
"Carlo Stonebanks" writes:
> I have the folder contents of postgresql-8.3.10\src\pl\tcl from a Linux
> build. From what I see it looks like I need to run the pltcl_loadmod.in as
> tcl script after every server start or bounce - could that be right?
No, you would run that once and it would put
On 09/30/2010 02:11 PM, Matthew Seaman wrote:
On 30/09/2010 12:31, Vincenzo Romano wrote:
2010/9/30 Ben Carbery:
Strange if this can't be done, I would have thought it a common request!
Just curiosity. Is there any other DB capable of such a thing?
MySQL does this using an alternate end-of
On 4/10/2010 5:20 PM, Alexander Farber wrote:
# rpm -qa | grep -i postgres
postgresql-8.1.21-1.el5_5.1
Mmm, elderly.
On Friday I've installed a cronjob (full source code at the bottom):
3 3 * * * psql -a -f
$HOME/bin/clean-phpbb-forum.sql
Do you rate-control
On Fri, Oct 1, 2010 at 11:40 AM, novnovice wrote:
> Thanks Greg. I'd had a quick look at bucardo and while it seems capable of
> doing the job (or helping to do that job), I was hoping there was something
> simpler. But I will have a closer look.
>
> Have you ever evaluated rubyrep (http://www.rub
I've upgraded my CentOS 5.5 VM to:
postgresql-libs-8.4.4-1PGDG.rhel5
postgresql-devel-8.4.4-1PGDG.rhel5
postgresql-8.4.4-1PGDG.rhel5
postgresql-contrib-8.4.4-1PGDG.rhel5
postgresql-docs-8.4.4-1PGDG.rhel5
postgresql-server-8.4.4-1PGDG.rhel5
postgresql-plperl-8.4.4-1PGDG.rhel5
and then have loaded
Is there any C libs out there that will abstract the SPI interface?
I have a number of functions that do input process output and
they are all almost identical (tablename fields, change)
I could abstract the code but would prefer to re-use an exissting abstraction
layer
as the less code I write
Hello Postgres users,
I have a Linux website with phpBB serving a small Facebook game:
# uname -a
Linux X 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:50:31 EDT 2010
x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/redhat-release
CentOS release 5.5 (Final)
# rpm -qa | grep -i postgres
postgresql-devel-8
Alexander Farber skrev 2010-10-04 11.20:
Hello Postgres users,
I have a Linux website with phpBB serving a small Facebook game:
# uname -a
Linux X 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:50:31 EDT 2010
x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/redhat-release
CentOS release 5.5 (Final)
#
On Sun, Oct 3, 2010 at 1:02 AM, Rajesh Kumar Mallah
wrote:
> As an enduser i setup SR based on
> http://wiki.postgresql.org/wiki/Streaming_Replication
> The master & standby are both powerful machines and are on same gigabit
> switch.
> Things worked as expected I updated 1000's of records in sing
I ran PgAdmin from 9.0RC1 in windows and selected
Tools/Server status for 8.2.4 server
After that messagebox with error
---
pgAdmin III
---
An error has occurred:
ERROR: cannot cast type xid to text
LINE 1: SELECT transaction::text, gid, prep
Thank you, I've enabled logging,
but couldn't see anything suspicious there.
Also the 60%-120% CPU-eating postmaster
processes are now suddenly gone.
I suspect this is some bug in the
postgresql-server-8.1.21-1.el5_5.1 delivered
with CenOS 5.5/64 bit, because I don't
have many simultaneous users
Hi,
I want to change the way PostgreSQL splits text into tokens, for example:
plainto_tsquery("v-74") should split it up as "v" & "74" instead of "v" &
"-74".
Another example:
select to_tsvector('NL83-V-74-001-001')'-001':5,6 '74':4 'nl83':2
'nl83-v':1 'v':3
Searching for 'v-71' does not fin
On 04/10/2010 17:01, Andrus wrote:
I ran PgAdmin from 9.0RC1 in windows and selected
Tools/Server status for 8.2.4 server
After that messagebox with error
---
pgAdmin III
---
An error has occurred:
ERROR: cannot cast type xid to text
LINE 1: SELEC
2010/10/4 Andrus :
> I ran PgAdmin from 9.0RC1 in windows and selected
> Tools/Server status for 8.2.4 server
>
> After that messagebox with error
> ---
> pgAdmin III
> ---
> An error has occurred:
>
> ERROR: cannot cast type xid to text
> LINE 1: SE
On Fri, Oct 01, 2010 at 11:27:11AM -0700, Aleksey Tsalolikhin wrote:
> How to see what SQL queries are associated with pg_locks, please?
Look at the pid column in pg_locks. It will match the procpid column in
pg_stat_activity.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.
In particular you'd want to use it to install the
"unknown" function from unknown.pltcl. After that, the "unknown"
function will be loaded automatically into new pltcl interpreters.
Is there a way to install my own "unkown" function, and to have it become
permanant with no startup required? I
On Oct 3, 10:58 pm, cr...@postnewspapers.com.au (Craig Ringer) wrote:
[sNip]
> Should win2k be declared dead and dropped from the supported platform
> list? It's over 10 years old, after all, and there's no evidence it's
> tested anymore.
[sNip]
I have one client who still uses Windows 2000, but i
Dear Masao ,
Thanks so much for the response ,
I actually i am in a position to do rigorous stress testing because i have
the machines at my disposal.
I am sorry that i was not in touch with the lists for a prolong duration and
could not followup much
on the discussions while HS & SR were being d
Dear Masao,
I would also like to inform that i observed the phenomenon only once. And i
am still not
too clear on the correct setup.
Regds
Rajesh Kumar Mallah.
>
> This looks like the bug of HS. But I'm not sure why KnownAssignedXids
> overflowed.
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRA
Hi all,
We're currently testing a new javascript change on the PostgreSQL
docs. This is to make sure monospaced fonts still appear at a
reasonable size between browsers. I'd appreciate it if some of you
could do some browser testing. http://magnus.webdev.postgresql.org/
Only docs for 8.3 and be
"Carlo Stonebanks" writes:
>> In particular you'd want to use it to install the
>> "unknown" function from unknown.pltcl. After that, the "unknown"
>> function will be loaded automatically into new pltcl interpreters.
> Is there a way to install my own "unkown" function, and to have it become
>
Specifically look into setting.
log_min_duration_statement (integer)
in the postgresql.conf file.
-Original Message-
From: Robert Gravsjö [mailto:tekniksupp...@blogg.se]
Sent: Monday, October 04, 2010 7:22 AM
To: Alexander Farber
Cc: pgsql-general@postgresql.org
Subject: Re: Any ad
Hi all.
I am trying to create two databases in two different machines connected
over the lan. Both the databases have similar tables and fields in them.
I will be updating database A always. I want the update to be backed up
to database B automatically during the night when no one will be usin
Hi All,
I'd like to do a data dump of a table to a CSV or XML file.
How would I do that?
I'm running on Postgres 8.3.8.
Thanks in advance.
Mary Wang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpre
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Wang, Mary Y
> Sent: Monday, October 04, 2010 1:00 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] How to data dump a table content to a CSV or XML
> format
On 10/04/2010 12:59 PM, Wang, Mary Y wrote:
Hi All,
I'd like to do a data dump of a table to a CSV or XML file.
How would I do that?
I'm running on Postgres 8.3.8.
Thanks in advance.
Mary Wang
As sql COPY"
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html
In psql \copy
http:/
The default psql -c record separator is a newline when output is the
screen, console or a file. But what if I'm required to send output to
a variable and not to a file (or standard output?)
command="`psql -c "SELECT * FROM pg_stat_database`"
when you retain the query result within the variable
2010/10/4 Thom Brown :
> Hi all,
>
> We're currently testing a new javascript change on the PostgreSQL
> docs. This is to make sure monospaced fonts still appear at a
> reasonable size between browsers. I'd appreciate it if some of you
> could do some browser testing. http://magnus.webdev.postgr
Thom Brown wrote on 04.10.2010 20:40:
Hi all,
We're currently testing a new javascript change on the PostgreSQL
docs. This is to make sure monospaced fonts still appear at a
reasonable size between browsers. I'd appreciate it if some of you
could do some browser testing. http://magnus.webdev.
On Mon, Oct 4, 2010 at 2:40 PM, Thom Brown wrote:
> Hi all,
>
> We're currently testing a new javascript change on the PostgreSQL
> docs. This is to make sure monospaced fonts still appear at a
> reasonable size between browsers. I'd appreciate it if some of you
> could do some browser testing.
Hi all,
This is more of an odd anoyance than anything, but for the past month or
so when I \q out of psql I have to wait 20-25 seconds for the return to
the shell prompt. This is the only copy of psql running and it doesn't
matter what database I'm connected to. I'm running 8.4.4 on OpenBSD
On 04/10/10 20:51, andrew harvey wrote:
The default psql -c record separator is a newline when output is the
screen, console or a file. But what if I'm required to send output to
a variable and not to a file (or standard output?)
command="`psql -c "SELECT * FROM pg_stat_database`"
I know tha
On Mon, Oct 04, 2010 at 12:51:11PM -0700, andrew harvey wrote:
> The default psql -c record separator is a newline when output is the
> screen, console or a file. But what if I'm required to send output to
> a variable and not to a file (or standard output?)
>
>
> command="`psql -c "SELECT * FRO
On 4 October 2010 21:58, Thomas Kellerer wrote:
> Thom Brown wrote on 04.10.2010 20:40:
>>
>> Hi all,
>>
>> We're currently testing a new javascript change on the PostgreSQL
>> docs. This is to make sure monospaced fonts still appear at a
>> reasonable size between browsers. I'd appreciate it if
Thom Brown wrote on 04.10.2010 23:24:
Do you see the reduction in size compared to the live site an issue?
No, not at all.
I just wanted to mention it, in case you are interested.
I think both sizes are just fine.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> This is more of an odd anoyance than anything, but for the past month or
> so when I \q out of psql I have to wait 20-25 seconds for the return to
> the shell prompt. This is the only copy of psql running and it doesn't
Perhaps there is a
On Mon, Oct 4, 2010 at 2:40 PM, Thom Brown wrote:
> Hi all,
>
> We're currently testing a new javascript change on the PostgreSQL
> docs. This is to make sure monospaced fonts still appear at a
> reasonable size between browsers. I'd appreciate it if some of you
> could do some browser testing.
Hi guys, in my typical "ignore the rules when I have an audience of
smart techie people", I thought I'd poll the group about software load
balancing. I know next to nothing about it, but I'm deploying my site
(built on Postgres 9.0 now!) within the next few days and at least
want a simple solution
On Mon, Oct 4, 2010 at 5:02 PM, Mike Christensen wrote:
> Hi guys, in my typical "ignore the rules when I have an audience of
> smart techie people", I thought I'd poll the group about software load
> balancing. I know next to nothing about it, but I'm deploying my site
> (built on Postgres 9.0 n
On 10/04/10 5:51 PM, Scott Marlowe wrote:
Build a light apache server and use mod proxy to reverse proxy the dir
where your dynamic pages come from on a heavy server.
or even lighttp or nginx or similar on the front end server. These
servers are very suitable for serving lots of static cont
I think you want something like :
http://www.postgresql.org/docs/8.4/interactive/backup.html
On 05/10/2010, at 7:02 AM, Sairam Krishnamurthy wrote:
> Hi all.
>
> I am trying to create two databases in two different machines connected over
> the lan. Both the databases have similar tables and f
Thanks, Pound sounds pretty awesome - looks like it'll do exactly what
I need.. Thanks!
On Mon, Oct 4, 2010 at 5:51 PM, Scott Marlowe wrote:
> On Mon, Oct 4, 2010 at 5:02 PM, Mike Christensen wrote:
>> Hi guys, in my typical "ignore the rules when I have an audience of
>> smart techie people",
Dear Sai,
Why do you want to update at nite only. You can setup streaming replication
with pgsql9.0 and
have it updated almost instantly.
However if you would want it that way only read about various backup
options in
the link that was provided.
regds
mallah.
On Mon, Oct 4, 2010 at 4:02 PM, Sa
Or in psql you can look at the help (\?) and set the output format to
unaligned, comma separated, and output the table to disk :
database=> \pset fieldsep ,
Field separator is ",".
database=> \a
Output format is unaligned.
database=> \o table.csv
database=> SELECT * FROM table;
database=> \o
che
On Mon, Oct 4, 2010 at 8:46 PM, Rajesh Kumar Mallah
wrote:
> Dear Sai,
>
> Why do you want to update at nite only. You can setup streaming replication
> with pgsql9.0 and
> have it updated almost instantly.
They could have something where they need a stable unchanging version
for testing, or they
On Tue, Oct 5, 2010 at 2:57 AM, Rajesh Kumar Mallah
wrote:
> I am currently aiming to setup only SR between 2 servers only.
"only SR" means that you don't need Hot Standby (i.e., you don't need to
run any query on the standby server)? If so, you can set wal_level to
archive instead of hot_standb
Howdy,
I've noticed that there is a difference in result of execution of the
following statement:
INSERT INTO testtable(col1) VALUES(NULL);
depending on whether the command is prepared or not.
If I call PQprepare/PQexecPrepared for the statement, the error "transaction
aborted" is returned with
if you want this to be for pltcl not pltclu... You're not going to be
able
to source random files from the filesystem.
Thanks - we're doing this using pltclu and have been using "source..." for 4
years with no trouble.
Well, you can use whatever "unknown" function you want, but it has to b
On Oct 4, 4:35 pm, li...@remoteinformation.com.au (Ben Madin) wrote:
> Or in psql you can look at the help (\?) and set the output format to
> unaligned, comma separated, and output the table to disk :
[sNip]
> > I'd like to do a data dump of a table to a CSV or XML file.
> > How would I do that?
On Oct 4, 11:40 am, t...@linux.com (Thom Brown) wrote:
> Hi all,
>
> We're currently testing a new javascript change on the PostgreSQL
> docs. This is to make sure monospaced fonts still appear at a
> reasonable size between browsers. I'd appreciate it if some of you
> could do some browser testi
Hi,
I am using Slony-I for replicating a database.I have a master database
and two slave databases in another server on the same host. I have done
all steps mentioned in
http://www.testdriveinteractive.com/files/Tutorial_All_PP_Slony_Replicat
ion.pdf, and started the Slony-I service. But the da
On Tue, 2010-10-05 at 10:19 +0530, Vishnu S. wrote:
> LOG: unexpected EOF on client connection
> ERROR: schema "_testcluster" does not exist at character 30
Did you run slonik_init_cluster?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository:
These three queries may help you to understand what's going on.
EXPLAIN ANALYZE SELECT count(catalog.id) FROM catalog;
EXPLAIN ANALYZE SELECT count(catalog.id) FROM catalog WHERE flag=false;
EXPLAIN ANALYZE SELECT count(DISTINCT catalog.id) FROM catalog WHERE flag=false;
Regards,
--
NAGAYASU Sat
63 matches
Mail list logo
