>
> Yeah, that's what it will look like if psql is using Apple's libedit
> library; it's unrelated to the server.
>
> I think libedit doesn't support control-r either, not totally sure
> though. In any case there are some known bugs in libedit that Apple's
> not been terribly swift to fix. I'd su
My .psql_history contains lines of the form.
select\040sum(price)\040from\040products\040p\040join\040
My psql client is 9.1.2 on Mac OS and server is linux 9.0.5
Is the version mismatch messing up this .psql_history file?
Also control-r to search the history isn't working at psql prompt from
Dear List
Since 9.0 comes out, I had been successfully using wal file shipping
readonly hotstandby feature in pg. I am currently trying to
reestablish a readonly slave after master node failure.
The newly established master server is working properly. I have
verified that WAL file shipping is
On Mon, May 9, 2011 at 10:50 PM, Merlin Moncure wrote:
> Now manybe *I'm* a little confused. Are you connecting to the write
> port (stunnel's secure port)? As I understand it, the stunnel pgsql
> protocol is such that the client side libpq application can connect to
> stunnel which unwraps the
On Mon, May 9, 2011 at 6:42 PM, Merlin Moncure wrote:
>> Thanks. Yes, when I installed the latest stunnel-4.36 it works.
>>
>> One strange thing I notice. When I do ssl connect with psql I am
>> supposed to get a message like
>>
>> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
>>
>> Wit
On Mon, May 9, 2011 at 4:37 PM, Merlin Moncure wrote:
>> I was not setting protocol. But since I got your message, I tried
>> 'protocol = pgsql' in stunnel.conf
>
> see:
> http://pgbouncer.projects.postgresql.org/doc/faq.html#_how_to_use_ssl_connections_with_pgbouncer
>
> "Use Stunnel. Since ver
On Mon, May 9, 2011 at 2:01 PM, Merlin Moncure wrote:
.
.
.
>> It seems to be shame that I have to run stunnel on the pg box as well.
>>
>> My question is that client only stunnel to pg server requiring ssl
>> connection is not expected to work? Or am I doing something wrong?
>
> what version st
Hi
My postgresql client (ejabberd postgresql lib) does not seem to be
capable of ssl connection to postgresql server (with hostssl in
pg_hba)
So I tried to use run stunnel on the client box (ejabberd). It
appears not to work.
Here is stunnel log on the client end
--
2011.05.09 0
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: canceling statement due to
conflict with recovery
DETAIL: User query might have needed to see row versions that must be
removed.
pg_dump: The command was: COPY public.i.. TO stdout;
pg_dumpall: pg_dump failed on database "
Hello
I have successfully used iptables to direct ports for other services.
For example I run apache on 8443 on 127.0.0.1 and
use iptable to direct traffic to public ip on 443. Trying the same
with postgresql does not seem to work properly.
I was wondering whether anyone has successfully used ip
Hello List
I have a nicely working system of maintaining a cold standby of master
8.1.11 server. System consists of a set of scripts to do a base
backup to standby and scheme to send wal files and restoring the cold
standby should the master server break down
I have another totally separate post
Sorry to top post but it's this email client ..
pg_hba.conf is bare bone
Besides it asks for certs but it obviously does not do SSL connection at the
end
On Nov 2, 2010 2:12 PM, "Ray Stell" wrote:
On Tue, Nov 02, 2010 at 01:54:34PM -0400, zhong ming wu wrote:
> On Tue, Nov
On Tue, Nov 2, 2010 at 1:43 PM, Ray Stell wrote:
>>
>> Good question. First, it's not easy to get confused like this because
server
>> logs lives in $PGDATA/pg_log/
>
>
> this is configurable in postgresql.conf. you can set the logs to any dir
> that exists and is writable by the software owner.
I looked on PG website but couldn't find admin email for this list
I would like list emails to have extra 'reply-to' header addressed to the
list
Is it too much to ask? When replying from a mobile client it can be tricky
without + even from a bigger client most often I forgot
On Tue, Nov 2, 2010 at 11:25 AM, Ray Stell wrote:
> On Tue, Nov 02, 2010 at 09:03:59AM -0400, zhong ming wu wrote:
>> On Mon, Nov 1, 2010 at 5:06 PM, Ray Stell wrote:
>> >
>> > no, that does not make sense to me, however, I don't have an 8.x to
play
>>
I don't recall this being an issue with 8.4 I am also using
Say your 8.1 server has SSL on. Even though pg_hba.conf have
host or hostnossl md5
either server or 8.1 psql insists that you have .postgresql/postgresql.*
Does that make sense to you?
Note: no "cert" in pg_hba.conf
On Mon, Oct 25, 2010 at 1:58 PM, Fredric Fredricson
wrote:
> On 10/25/2010 01:19 PM, David W Noon wrote:
>>
> Ah, yes of course, It was a while ago I played with cron.
> "man 5 crontab" is also a good command to know, or
> "info crontab" if you prefer those modern inventions.
>
This is nothing t
On Sat, Oct 23, 2010 at 11:48 AM, Tom Lane wrote:
>
> A more recent version of Postgres would break that down for you: it
> means the subprocess exited with exit(127). A look in the shell
> man page suggests this is a "command not found" failure. Maybe
> there's something flaky about where you h
Hello
I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync
For some reason it failed recently with "return codes 32512" and I couldn't
find this num. as a valid rsync exit code
During the time that the error was going on I tried the rsync command
manually and didn't error
C
It seems that one cannot use the variable name that is the same as the
column name of a relation like in the following function
--
create or replace function bla() returns void language plpgsql as $$
declare
email varchar;
begin
select email into email from pass where id=1;
On Tue, Aug 17, 2010 at 4:15 AM, Philippe Lang
wrote:
>> Hi,
>>
>> I have a non-reentrant plperlu function, which does no database
>> modification. It basically stores input data into a file, calls a unix
>> shell command, and reads the result back from another file.
>>
>> I don't really care abou
On Sun, Aug 15, 2010 at 12:21 PM, zhong ming wu wrote:
> On Sun, Aug 15, 2010 at 11:57 AM, Joe Conway wrote:
>> On 08/15/2010 07:57 AM, zhong ming wu wrote:
>>> Here is what I have tried
>>>
>>> create or replace function te(out a int,out b int) returns set
On Sun, Aug 15, 2010 at 6:18 AM, Mike Christensen wrote:
> On Sun, Aug 15, 2010 at 3:10 AM, Craig Ringer
> wrote:
>>
>> On 15/08/10 18:00, zhong ming wu wrote:
>>
>> > Thanks for any better solution to this
>>
>> CREATE TYPE
>>
>> Howev
Hello List,
I have a plpgsql function returning a set of records. The record is
effectively a join of some tables.
For example, table a (column a1,column a2,column a3,column a4)
table b(column b1,column b2,column b4)
I am returning a set of (a2,a4,b2). What I do now is to create a empty table
On Wed, Aug 4, 2010 at 7:32 AM, Machiel Richards wrote:
> Good day all
>
> I am looking for some info / resources where I can learn how to write
> database procedures, functions,etc?
>
> I am a total newbie to this and will need to learn from scratch
>
> Would appreciate the help
On Tue, Jul 27, 2010 at 9:58 PM, Howard Rogers wrote:
> Thanks to some very helpful input here in earlier threads, I was
> finally able to pull together a working prototype Full Text Search
> 'engine' on PostgreSQL and compare it directly to the way the
> production Oracle Text works. The good new
Will running the following on your file useful
http://www.gnu.org/software/recode/
It helped me with a pg_dump file in the past
On Sun, Jul 18, 2010 at 5:51 PM, Andre Lopes wrote:
> Hi,
>
> I'am trying to import an SQL file with 3gb of INSERTS. I must to change the
> encode of the file to UTF8,
On Mon, Jun 28, 2010 at 5:29 AM, Max Williams wrote:
> Hi,
>
> I am logging long queries with log_min_duration_statement but would like to
> see the parameters for parameterized queries. Eg…
>
Consider increasing log level. I think you need to go to "debug" at least.
--
Sent via pgsql-general
Dear List
Where can I find this mapping of oid to pg data types mentioned in
libpq documentation?
Why is such information not mentioned in the documentation? A general
knowledge?
Thanks
Mr Wi
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
On Thu, Jun 3, 2010 at 2:15 AM, John R Pierce wrote:
> zhong ming wu wrote:
>>
>> ...
>> This machine is RHEL 5.5 and has both RH stock postgres 8.1.18 in
>
> you probably need to either use "-R $HOME/local/lib" on the link command to
> specify the run
I am trying to compile and run c program which reads the journal of an
ancient propriety database
and copy these transactions over to postgres. The process I follow is
by trial and error and made worse
by the fact that I haven't before made c program which talks to
postgres and because I have to u
On Tue, Apr 27, 2010 at 11:02 AM, Tom Lane wrote:
> zhong ming wu writes:
>
> The closest thing I can find to that in the code is
>
> cannot convert abstime "invalid" to timestamp
Yes this is the message.
There were invalid values in that table at first. Then I
I have a postgres table with a column type abstime. (all data in this
database are loaded from an ancient propriety database)
When I filter data from this table with a specific date range on this
column it works. When I filter with a different date range
it gives me an error like
invalid abstim
Dear List
I need to build a postgres on a linux machine that I don't have root access.
I built readline from source and installed it with prefix of /home/me/local
readline library are in /home/me/local/lib and headers files are in
/home/me/local/include/readline
After explicitly specfying these
On Sun, Mar 28, 2010 at 8:20 PM, Yar Tykhiy wrote:
>
> Guys, I'm afraid there may be some confusion here. I've got a warm
> standby happily running with simple home-made archive and restore
> scripts on a legacy Postgresql installation as old as 8.0. And yes, I
> did failover multiple times (I
I have been using this one liner c function that I call my_now() to
get the number of seconds since some fixed point in the past. I find
it more convenient than built-in now()
and if I want abstime I do abstime(my_now()). Thing is everytime I
do a major version upgrade I had to recompile this an
Dear List
I use plpgsql function as a postfix mailserver look-up table. For
example to look up virtual email address.
If I don't host this email address, then the function returns null.
Because it's a 1 row of null value postfix logs a warning message.
Although it's harmless in that postfix takes
On Wed, Mar 17, 2010 at 12:00 AM, Osvaldo Kussama
wrote:
>
> For a RETURN SETOF function use:
>
> SELECT * FROM aplpgsqlfunction('%u');
>
> http://www.postgresql.org/docs/current/interactive/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
>
> Osvaldo
>
I didn't know about RETURN SETO
Hello
I have tried to return rowtypes and record from plpgsql
but they don't look like anything what is returned from select a,b,c
from table d;
My application is for dovecot imap server userdb where I can only put
one sql statement
to retrieve a few items. I need to perform some logic in retrie
Dear List
Is it possible to have a warm standby with 8.1? I have set up log
shipping to standby server but it seems that i cannot make it read any
subsequent
walfiles except the first one played with initial data.With pg_standy
with 8.2+ it is so easy to make it work but I would also like to have
Hello,
I'm a long time user and I had always installed postgres by compiling
from source. I recently moved to a new environment where
everything is installed as rpm and plus I need to install a newer
postgres for testing while keeping the existing version in place.
That leads me to repackage postg
Thanks. That works nicely.
On Tue, Jan 26, 2010 at 8:00 PM, Greg Smith wrote:
> zhong ming wu wrote:
>>
>> Is there a way to figure out from binaries what options were used to
>> compile/config? For example with apache I can do "httpd -l"
>>
>
> p
Is there a way to figure out from binaries what options were used to
compile/config? For example with apache I can do "httpd -l"
Thanks
mr. wu
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
43 matches
Mail list logo
