Greg Smith wrote:
On Sat, 26 Jul 2008, Zoltan Boszormenyi wrote:
Zoltan Boszormenyi �rta:
These three settings were also set with "sysctl -w ..." to take effect
immediately.
Rebooting FreeBSD solved it. Huh? Is it really like W#&@$#&?
Looks like the PostgreSQL documentation here (
http://w
On 27/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:
> Well, that's the problem, Andrej. I have that script, and it worked fine
> with postgres-6.x through -8.1, but failed to correctly start the
> postmaster after the system reboot.
I thought we had established that this issue was caused by
On Sat, 26 Jul 2008, Steve Atkins wrote:
The obvious thing to do is write a wrapper that will transparently run the
right version of psql for the database it's connecting to. Has anyone already
done that?
Several times, and I never seem to have the previous rev around when
writing a new one
On Sat, 26 Jul 2008, Tom Lane wrote:
Startup scripts invariably run as root, so 'su' isn't going to ask for a
password...
Tom,
That occurred to me after I wrote the message. Think that I'll tune the
script to use a command that I know is working with 8.3.3.
Many thanks,
Rich
--
Richard B
On Sun, 27 Jul 2008, Andrej Ricnik-Bay wrote:
if [ -x /etc/rc.d/rc.postgres ]; then
/etc/rc.d/rc.postgres start
fi
to your /etc/rc.d/rc.local
Well, that's the problem, Andrej. I have that script, and it worked fine
with postgres-6.x through -8.1, but failed to correctly start the postmaster
Hello,
I have to load xml file data into postgresql database table using a
stored procedure,but I didn't have any idea how to start it.Can you please help
me how to do this.Your suggestion is greatly appreciated.Its very important to
me.
Thanks in advance,
Avin.
On 27/07/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> Startup scripts invariably run as root, so 'su' isn't going to ask
> for a password...
And it's nothing to worry about because the script he's using
is suing to the postgres user anyway ...
> regards, tom lane
Cheerw,
A
yes, it's work.
thank u very much!
Regards
Yi
On Sat, 2008-07-26 at 21:37 +0200, Pavel Stehule wrote:
> hello
>
> try
>
> create function uniq(anyarray)
> returns anyarray as $$
> select array(select distinct $1[i] from
> generate_series(array_lower($1,1), array_upper($1,1)) g(i));
> $$ language
Tino Wildenhain wrote:
Bill Wordsworth wrote:
...
PHP is faster than Python, has a smaller memory foot-print than
Python, has better SOAP features than Python, and is better suited for
the web than Python. Python is better suited for the
cli/mac/desktop/phone.
Do you have proof for that? Or i
Rich Shepard <[EMAIL PROTECTED]> writes:
>My question is how best to modify the startup script so the postmaster
> fires up when the system is rebooted. I don't see an option to 'su' to
> specify the postgres user's password so I can script this.
Startup scripts invariably run as root, so 'su'
On 27/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:
> Andrej,
Hi Rich,
> I found the thread in the archives for June of this year.
>
> Re-reading the posted results of running initdb I tried a different
> approach to starting the server. Instead of using pg_ctl I used 'postgres
> -D
> /
Bill Wordsworth wrote:
...
PHP is faster than Python, has a smaller memory foot-print than
Python, has better SOAP features than Python, and is better suited for
the web than Python. Python is better suited for the
cli/mac/desktop/phone.
Do you have proof for that? Or is this similar to "MySQL
On Wed, 23 Jul 2008, Andrej Ricnik-Bay wrote:
Now there's an interesting piece of information :) How long
ago did you upgrade it?
Andrej,
I found the thread in the archives for June of this year.
Re-reading the posted results of running initdb I tried a different
approach to starting the
hello
try
create function uniq(anyarray)
returns anyarray as $$
select array(select distinct $1[i] from
generate_series(array_lower($1,1), array_upper($1,1)) g(i));
$$ language sql strict immutable;
postgres=# select uniq(array[1,2,3,1,2,3,5,2,2]);
uniq
---
{1,2,3,5}
(1 row)
regards
Using 8.1
# create table foo (a integer, b integer);
# create table baz (b integer, c integer);
# insert into foo values (8,9);
# insert into baz values (9,1);
# select * from foo;
a | b
---+---
8 | 9
(1 row)
# select * from baz;
b | c
---+---
9 | 1
(1 row)
# create view foobaz as select foo.
hi all:
if I create an array '{44,55,66,c4,55,66,b4,55,66}',
how to remove the duplicate elements(55, 66) from it, after remove, the
array will be
'{44,55,66,c4,b4}'
thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
On Jul 26, 2008, at 2:32 AM, "Leif B. Kristensen"
<[EMAIL PROTECTED]> wrote:
On Saturday 26. July 2008, Owen Hartnett wrote:
Probably some funky stuff with the router (not one of their expensive
ones) that caused all the consternation, but I originally thought
corrupt database (because I co
I have a bunch of different version of postgresql installed, from 7.0
on forward, on various servers. As psql is fairly version specific,
and tends to misbehave if the client and server versions don't match,
I usually need to remember which version is running on which machine
and port.
Th
On Fri, Jul 25, 2008 at 4:29 PM, Bill Wordsworth
<[EMAIL PROTECTED]> wrote:
> years. It is newbies like him and fan-boys of Ruby/Python/Perl who
> give PHP a bad name. But I fail to understand the little animosity
> within some PostgreSQL users to PHP- is it the LAMP stack?
On Fri, Jul 25, 2008 at
Leif B. Kristensen wrote:
On Friday 25. July 2008, Christophe wrote:
...
My 2 cents: The prime reason for the popularity of PHP is probably the
very gentle learning curve. You can start with a static HTML page, and
introduce a few PHP snippets to show dynamic content. For us
self-taught peop
Joshua D. Drake wrote:
On Sat, 2008-07-26 at 11:13 +0930, admin wrote:
Anyway, while I'm quite happy to continue banging out things that "just
work" in PHP for the time being, you suggest (in a subsequent post) that
there is one scripting language in particular that you'd use ... might I
enqu
Hi,
Aarni Ruuhimäki wrote:
On Friday 25 July 2008 15:33, you wrote:
I would avoid that in favour of using $HOME/.pgpass
http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html
HTH
Tino
Hi,
Quite right you are. Or something like this?
require("/eg/unknown_path/deep_somewhere_els
Zoltan Boszormenyi írta:
> Joshua D. Drake írta:
>
>> On Fri, 2008-07-25 at 22:39 +0200, Zoltan Boszormenyi wrote:
>>
>>
>>> Hi,
>>>
>>> is there anyone using PostgreSQL on FreeBSD 7.0 starting from scratch?
>>> I compiled 8.3.3 and wanted to run initdb in my home directory but
>>> it fa
23 matches
Mail list logo
