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
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
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
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 the
Derk Jan Horstman dj.horst...@anva.nl 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
Carlo Stonebanks stonec.regis...@sympatico.ca 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
On 09/30/2010 02:11 PM, Matthew Seaman wrote:
On 30/09/2010 12:31, Vincenzo Romano wrote:
2010/9/30 Ben Carberyben.carb...@gmail.com:
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
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 novnov...@gmail.com 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
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
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
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
mallah.raj...@gmail.com 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
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,
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 find the
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:
2010/10/4 Andrus kobrule...@hot.ee:
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
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
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 don't
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
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
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 TELEGRAPH AND
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
Carlo Stonebanks stonec.regis...@sympatico.ca 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
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
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
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:
-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
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 t...@linux.com:
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.
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.
On Mon, Oct 4, 2010 at 2:40 PM, Thom Brown t...@linux.com 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
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 that,
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 * FROM
On 4 October 2010 21:58, Thomas Kellerer spam_ea...@gmx.net 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
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
-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 an
On Mon, Oct 4, 2010 at 2:40 PM, Thom Brown t...@linux.com 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
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 m...@kitchenpc.com 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
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
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
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 scott.marl...@gmail.com wrote:
On Mon, Oct 4, 2010 at 5:02 PM, Mike Christensen m...@kitchenpc.com wrote:
Hi guys, in my typical ignore the rules when I have an
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,
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
cheers
On Mon, Oct 4, 2010 at 8:46 PM, Rajesh Kumar Mallah
mallah.raj...@gmail.com 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
On Tue, Oct 5, 2010 at 2:57 AM, Rajesh Kumar Mallah
mallah.raj...@gmail.com 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
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 be
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 testing.
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
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:
62 matches
Mail list logo
