> The following listening worker thread behaves as expected if I insert/delete
> rows into/from table "t1" in psql prompt.
>
> My trouble is when the SQL execution worker thread inserts/ deletes rows
> into/from table "t1", the listening worker thread then goes crazy:
> PQnotifies() always retu
seil...@so-net.net.tw wrote:
The following listening worker thread behaves as expected if I insert/delete rows
into/from table "t1" in psql prompt.
My trouble is when the SQL execution worker thread inserts/ deletes rows into/from table
"t1", the listening worker thread then goes crazy: PQnoti
> Well this has definitely moved up a support level and past anything I
> know about.
> For the record what version of FreeBSD are you running in case someone
> is searching the archives?
Any help is always appreciated.
FreeBSD 8.3-RELEASE-p5. (I wonder if upgrading to 9.1 would do anything..)
> Did you use ports to install postgresql?
Yes
> What is the version of postgresql and freebsd you are using?
postgresql client and server v. 9.2.2. If all else fails I could try
downgrading to a previous version of postgres.
FreeBSD 8.3-RELEASE-p5
> I am getting a different output while runni
On Fri, Dec 14, 2012 at 4:28 PM, David Noel wrote:
> > Did you use ports to install postgresql?
>
> Yes
>
> > What is the version of postgresql and freebsd you are using?
>
> postgresql client and server v. 9.2.2. If all else fails I could try
> downgrading to a previous version of postgres.
>
>
Hi,
On 14 December 2012 17:56, a...@hsk.hk wrote:
> I could see that it would install older PostgreSQL 9.1 and
> postgresql-contrib-9.1. As I already have 9.2.1 and do not want to have
> older version 9.1 in parallel, I aborted the apt install.
>
> How can I get pure postgresql-contrib for Postg
Hi, got it installed, thanks
On 14 Dec 2012, at 7:36 PM, Ondrej Ivanič wrote:
> Hi,
>
> On 14 December 2012 17:56, a...@hsk.hk wrote:
>> I could see that it would install older PostgreSQL 9.1 and
>> postgresql-contrib-9.1. As I already have 9.2.1 and do not want to have
>> older version 9.1 i
On 12/13/12, David Noel wrote:
> I'm running into the following error message when running initdb (FreeBSD
> host):
>
> ygg# /usr/local/etc/rc.d/postgresql initdb -D /zdb/pgsql/data --debug
> The files belonging to this database system will be owned by user "pgsql".
> This user must also own th
Thank you Karl.
I am trying to determine on the slave itself whether streaming replication
(i.e. WAL receiver process) is active or not, similar to checking
pg_stat_replication on the master. In fact, this is part of a larger module I
am building to control the databases and automate failovers
Yeah, I agree this is the right answer here, since you're using JDBC. By
the time you get a String from the MySQL driver, it's already in Java's
2-bytes-per-char format. And the Postgres driver will deal with the
encoding on the output side. So the code I provided won't help you. I'm
afraid I don'
On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter wrote:
> Em 13/12/2012 20:10, Merlin Moncure escreveu:
>
>> On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter
>> wrote:
>>>
>>> Has anyone created a XML Schema that would represent PostgreSQL database
>>> with all (or at least, major) structures?
>>
>>
I wish to run an instance of PG-9.2 concurrently with our production
version (9.1). I have changed the listening port number.
listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, localhost'
#port = 5432# (change requires restart)
port = 5433
However, I am getting th
On 12/14/2012 04:08 AM, David Noel wrote:
Interestingly, I have a second--virtually identical--server that I
just tried initdb on. FreeBSD 8.3-RELEASE-p5, postgresql-server-9.2.2.
Exact same "FATAL: could not open file pg_xlog" error. So it is
reproducible.
Does virtually identical extend to
>> Interestingly, I have a second--virtually identical--server that I
>> just tried initdb on. FreeBSD 8.3-RELEASE-p5, postgresql-server-9.2.2.
>> Exact same "FATAL: could not open file pg_xlog" error. So it is
>> reproducible.
>
> Does virtually identical extend to architecture, amd64?
Yes... and
Hi,
Is this an RPM installation? If so, you also need to change the port in the
init script, too.
Regards, Devrim
"James B. Byrne" wrote:
>I wish to run an instance of PG-9.2 concurrently with our production
>version (9.1). I have changed the listening port number.
>
>listen_addresses = 'pgs
On 12/14/2012 06:26 AM, James B. Byrne wrote:
I wish to run an instance of PG-9.2 concurrently with our production
version (9.1). I have changed the listening port number.
listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, localhost'
#port = 5432# (change require
On 12/13/2012 06:51 PM, Alvaro Herrera wrote:
Alejandro Carrillo escribió:
Hi,
1) Anybody knows how to create a table using a table
file? It isn't a fdw, is a file that compose the table in postgresql and
get with the pg_relation_filepath function. Ex:
select pg_relation_filepath('pg_proc'
On Fri, December 14, 2012 09:40, Adrian Klaver wrote:
> On 12/14/2012 06:26 AM, James B. Byrne wrote:
>> I wish to run an instance of PG-9.2 concurrently with our production
>> version (9.1). I have changed the listening port number.
>>
>> listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, lo
On 12/14/2012 06:06 AM, Emi Lu wrote:
What does OP stand for?
Original Poster.
Emi
--
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello
I was just wondering the same. As for the slave, it seems to me that
the "ps fax" output "postgres: startup process recovering" is at least
a quick way to check if the replication client has synced.
In a case where e.g. the slave was down for a while and then unsuccessfully
waits for WAL
On 14/12/2012 16:37, Devrim Gündüz wrote:
Hi,
Is this an RPM installation? If so, you also need to change the port in
the init script, too.
Or if it's rhel/centos/sciencific like linux, you can specify in
/etc/sysconfig/pgsql/postgresql-9.2:
PGPORT=5433
Regards, Devrim
"James B. Byrne"
On 12/14/2012 06:48 AM, James B. Byrne wrote:
And this is the running instance:
service postgresql-9.1 status
postgresql-9.1 (pid 1299) is running...
So, I am fairly sure that I am trying to get 9.2 started and failing
and not trying to start another instance of 9.1.
Assuming an RPM instal
On 12/14/2012 09:49 AM, Adrian Klaver wrote:
Original Poster
Thanks. And more info:
Mysql
+--++
| Variable_name| Value |
+--++
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_
Emi Lu writes:
> For now, through the following method, all letters are correctly
> transformed except "È".
Meh. That character renders as \310 in your mail, which is not an
assigned code in ISO 8859-1. The numerically corresponding Unicode
value would be U+0090, which is an unspecified contro
I'm trying to create an implicit cast from an unknown type into a text array
type by creating a simple array of size 1. e.g.
create function textarray(unknown)
returns text[]
as 'select ARRAY[$1::text];'
language sql
immutable;
create cast (unknown as text[]) with function textarray(unknown) as
i
On Fri, December 14, 2012 09:52, Adrian Klaver wrote:
>
> Assuming an RPM install, see Devrims reply.
Might one inquire as to why it is necessary to override the
configuration file in the startup script?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
On Fri, Dec 14, 2012 at 9:16 AM, joshua wrote:
> I'm trying to create an implicit cast from an unknown type into a text array
> type by creating a simple array of size 1. e.g.
>
> create function textarray(unknown)
> returns text[]
> as 'select ARRAY[$1::text];'
> language sql
> immutable;
>
> cre
Adrian Klaver writes:
> On 12/13/2012 06:51 PM, Alvaro Herrera wrote:
>> Make sure the server is down and replace a table's file with the file
>> you have. You can just create a dummy empty table with exactly the same
>> row type as the one that had the table the file was for; you need to
>> recr
Thanks, that function does help, but it still cannot cast directly to text[];
The point of the functions was only ever to allow for an implicit cast to
text[];
My goal is to be able to copy from a simple csv with nonarray entries
("1,2,3,...") and extract text arrays when the target table calls for
I wrote:
> Meh. That character renders as \310 in your mail, which is not an
> assigned code in ISO 8859-1. The numerically corresponding Unicode
> value would be U+0090, which is an unspecified control character.
Oh, scratch that, apparently I can't do hex/octal arithmetic in my
head first thin
joshua writes:
> I'm trying to create an implicit cast from an unknown type into a text array
> type by creating a simple array of size 1. e.g.
> create function textarray(unknown)
> returns text[]
> as 'select ARRAY[$1::text];'
> language sql
> immutable;
> create cast (unknown as text[]) with
On 12/14/2012 07:30 AM, Tom Lane wrote:
Adrian Klaver writes:
On 12/13/2012 06:51 PM, Alvaro Herrera wrote:
Make sure the server is down and replace a table's file with the file
you have. You can just create a dummy empty table with exactly the same
row type as the one that had the table the
On Fri, Dec 14, 2012 at 9:32 AM, joshua wrote:
> Thanks, that function does help, but it still cannot cast directly to text[];
> The point of the functions was only ever to allow for an implicit cast to
> text[];
I'm not parsing that. Why do you need an explicit cast?
> My goal is to be able to
On 12/14/2012 07:35 AM, Tom Lane wrote:
I wrote:
Meh. That character renders as \310 in your mail, which is not an
assigned code in ISO 8859-1. The numerically corresponding Unicode
value would be U+0090, which is an unspecified control character.
Oh, scratch that, apparently I can't do hex/
"James B. Byrne" writes:
> On Fri, December 14, 2012 09:52, Adrian Klaver wrote:
>> Assuming an RPM install, see Devrims reply.
> Might one inquire as to why it is necessary to override the
> configuration file in the startup script?
There's some background about that here:
https://bugzilla.redh
Tom-
My apologies, I'm still somewhat new to this. Specifically, I'm dealing with
COPY FROM CSV. I had assumed that since a csv is essentially a pile of text
and COPY FROM is smart enough to interpret all sorts of csv entries into
postgresql data types that if I wanted to allow a nonstandard conver
On Fri, Dec 14, 2012 at 9:52 AM, joshua wrote:
> Tom-
> My apologies, I'm still somewhat new to this. Specifically, I'm dealing with
> COPY FROM CSV. I had assumed that since a csv is essentially a pile of text
> and COPY FROM is smart enough to interpret all sorts of csv entries into
> postgresql
Merlin Moncure-2 wrote
> If input csv doesn't match your destination structure, then staging
> the input to a temporary work table and processing the transformation
> with a query is really the way to go. Hacking casts is about as ugly
> as it gets.
>
> merlin
Thanks. I thought that might be the
But pg_dirty_read only runs in Linux. It doesnt run in windows.
>
> De: Alvaro Herrera
>Para: Alejandro Carrillo
>CC: "pgsql-general@postgresql.org"
>Enviado: Jueves 13 de diciembre de 2012 21:51
>Asunto: Re: [GENERAL] Read recover rows
>
>Alejandro Carril
Em 14/12/2012 12:21, Merlin Moncure escreveu:
On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter wrote:
Em 13/12/2012 20:10, Merlin Moncure escreveu:
On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter
wrote:
Has anyone created a XML Schema that would represent PostgreSQL database
with all (or at le
joshua writes:
> My apologies, I'm still somewhat new to this. Specifically, I'm dealing with
> COPY FROM CSV. I had assumed that since a csv is essentially a pile of text
> and COPY FROM is smart enough to interpret all sorts of csv entries into
> postgresql data types that if I wanted to allow a
On Fri, Dec 14, 2012 at 9:47 PM, Edson Richter wrote:
> Em 14/12/2012 12:21, Merlin Moncure escreveu:
>
> On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter
>> wrote:
>>
>>> Em 13/12/2012 20:10, Merlin Moncure escreveu:
>>>
>>> On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter <
edsonrich...@hotm
Tom Lane-2 wrote
> COPY is not smart at all. It just looks at the column types of the
> target table and assumes that the incoming data is of those types.
> (More precisely, it applies the input conversion function of each
> column's data type, after having separated and de-escaped the text
> acco
Hello,
Can anyone please figure out this ?
Begin forwarded message:
> From: dmp
> Subject: Re: [JDBC] Fwd: [ADMIN] Confuse about the behaveior of
> PreparedStatement.executeBatch (jdbc)
> Date: December 15, 2012 12:30:50 AM GMT+08:00
> To: Haifeng Liu , pgsql-j...@postgresql.org
>
> Hello,
>
On Fri, Dec 14, 2012 at 10:17 AM, Edson Richter
wrote:
> Em 14/12/2012 12:21, Merlin Moncure escreveu:
>
>> On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter
>> wrote:
>>>
>>> Em 13/12/2012 20:10, Merlin Moncure escreveu:
>>>
On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter
wrote:
Haifeng Liu wrote:
> Can anyone please figure out this ?
This was just answered on the JDBC list by Kris Jurka:
Internally the driver splits each batch into sub-batches of 250 to send to
the server to reduce the possibility of deadlocking the network
connection. When auto-commit is enabled in
On Fri, December 14, 2012 10:21, James B. Byrne wrote:
>
> On Fri, December 14, 2012 09:52, Adrian Klaver wrote:
>
>>
>> Assuming an RPM install, see Devrims reply.
>
> Might one inquire as to why it is necessary to override the
> configuration file in the startup script?
This is a patch for /etc
On Fri, December 14, 2012 10:21, James B. Byrne wrote:
>
> This is a patch for /etc/init.d/postgresql-9.2 to retrieve the port
> from the postgresql.conf file and override the default setting if it
>
A slight, but important, correction that handles leading white space
in the first selection:
76a
Gents,
after restart service is not coming up, seems like something is corrupted.
can i get recover data somehow?[?]
2012-12-14 17:49:28 EET LOG: could not create IPv6 socket: Address family
not supported by protocol
2012-12-14 17:49:28 EET LOG: database system was interrupted while in
recov
David Noel writes:
> I didn't have any luck with the rc script but I was able to use it to
> get a ktrace dump as root (ktrace as user pgsql doesn't seem to work).
> So hopefully that will show something(!)
The relevant part of the ktrace output is
71502 postgres CALL unlink(0x7fffc130)
7
Hello All,
Meh. That character renders as \310 in your mail, which is not an
assigned code in ISO 8859-1. The numerically corresponding Unicode
value would be U+0090, which is an unspecified control character.
Oh, scratch that, apparently I can't do hex/octal arithmetic in my
head first thing
Alejandro Carrillo escribió:
> But pg_dirty_read only runs in Linux. It doesnt run in windows.
So port it. There's no fundamental reason for it not to work.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgs
On 12/14/12, Tom Lane wrote:
> David Noel writes:
>> I didn't have any luck with the rc script but I was able to use it to
>> get a ktrace dump as root (ktrace as user pgsql doesn't seem to work).
>> So hopefully that will show something(!)
>
> The relevant part of the ktrace output is
>
> 71502
I just discovered a non PostgreSQL problem (but I was suspecting all the
time from PostgreSQL).
I'm recording this because would save lot of time from others in the
list, since my problem is already solved.
During this day, we had very busy servers and suddenly we started to get
error 500 an
I modified the
shared_buffer=50 MB
and
maintenance_work_mem = 50 MB
But still getting the same error.
On Thu, Dec 13, 2012 at 7:36 PM, Kevin Grittner wrote:
> AI Rumman wrote:
>
> I am going to restore a 6 Gb database in my development machine
> which is running on Centos 5.6 with memory 1 GB.
On 12/14/2012 01:37 PM, Emi Lu wrote:
Hello All,
Meh. That character renders as \310 in your mail, which is not an
assigned code in ISO 8859-1. The numerically corresponding Unicode
value would be U+0090, which is an unspecified control character.
Oh, scratch that, apparently I can't do hex/
Hi,
I have an index on a column that can be nullable. I decide the column
shouldn't be nullable anymore. So I alter the column to be not
nullable.
That "alter column" query does a full table scan, which can be painful
for large tables. Couldn't that index be used instead?
Thanks,
Joe
--
Sent
David Noel writes:
> On 12/14/12, Tom Lane wrote:
>> This corresponds to the execution of XLogFileInit(), and what's
>> evidently happening is that we successfully create and zero-fill
>> the first xlog segment file under a temporary name, but then
>> the attempt to rename it into place with link
You do not log failed connection attempts from your Java application?
Your desire is commendable but is your only advice: "don't set connection
timeout to 2ms"?
What could these products (not you, by setting up better logging) do to
minimize the amount of time you had to spend diagnosing the prob
AI Rumman wrote:
> I modified the
> shared_buffer=50 MB
> and
> maintenance_work_mem = 50 MB
>
> But still getting the same error.
I hope you restarted the PostgreSQL server? If so, pg_restore might
just need more RAM than that machine has to deal with that
particular database. You might try a t
Em 14/12/2012 18:14, David Johnston escreveu:
You do not log failed connection attempts from your Java application?
Can you imagine 100 users attempting (and failing) to get connection
every 2 milliseconds would just drop all the server :-)
Your desire is commendable but is your only advice:
Joe Van Dyk wrote:
> I have an index on a column that can be nullable. I decide the column
> shouldn't be nullable anymore. So I alter the column to be not
> nullable.
>
> That "alter column" query does a full table scan, which can be painful
> for large tables. Couldn't that index be used instea
Having got the 9.2 instance running in parallel with the previous
version I am now encountering this difficulty:
Couldn't create database for {"adapter"=>"postgresql",
"collate"=>"en_US.UTF-8", "ctype"=>"en_US.UTF-8", "encoding"=>"UTF8",
"database"=>"hll_th_forex_development",
"host"=>"inet01.hami
"James B. Byrne" writes:
> PG::Error: ERROR: encoding "UTF8" does not match locale
> "en...@-mmm-dd.utf-8"
> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1".
> : CREATE DATABASE "hll_th_forex_test" ENCODING = 'UTF8' TEMPLATE =
> "template1"
> I am constructing this remotely u
> You need to talk to some FreeBSD kernel hackers about why link()
> might be failing here. Since you see it on UFS too, we can probably
> exonerate the ZFS filesystem-specific code.
>
> I did some googling and found that EPERM can be issued if the filesystem
> doesn't support hard links (which sh
65 matches
Mail list logo
