Hi Everybody,
Is it possible to move the directory associated to a tablespace and
update that information in the postgres cluster?
I was expecting something like : ALTER TABLESPACE LOCATION "C:\..." but
found no such usage. Looking it up in the documentation I found that on
linux one could
- sh
2008/9/7 Filip Rembiałkowski <[EMAIL PROTECTED]>:
> 2008/9/7 c k <[EMAIL PROTECTED]>:
>> Hello,
>> I have a question regarding secure connections between pg clients and pg
>> server. As per manual for 8.3 we can use openssl for this purpose. does odbc
>> driver supports it and how? Is there any oth
That explains it... I thought it was a precent encoding but at the same
time a strange place for a control character.
Regards,
Ben Kim
On Mon, 8 Sep 2008, Alvaro Herrera wrote:
ERROR: invalid input syntax for type inet:
"fe80::104d:416e:a8dc:c02e%12"
SQL state: 22P02
Interesting.
Whe
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> ERROR: invalid input syntax for type inet:
> "fe80::104d:416e:a8dc:c02e%12"
>
> SQL state: 22P02
> Interesting.
> When we HAVE_IPV6, there's code to remove stuff after a % in an address.
We do now ... it wasn't there in 8.2.0.
http://archives.postg
>> ERROR: invalid input syntax for type inet:
>> "fe80::104d:416e:a8dc:c02e%12"
>>
>> SQL state: 22P02
Interesting.
When we HAVE_IPV6, there's code to remove stuff after a % in an address.
My bet is that what you're running was not compiled with HAVE_IPV6 and
so the code is not executed. Obvio
Sorry, I apologize for the mistake. %20 is the space, and the extra %12
seems to be DC3 (device control 3).
Regards,
Ben Kim
On Mon, 8 Sep 2008, Ben Kim wrote:
fe80::104d:416e:a8dc:c02e %12
Since %12 is a "space" character, it seems first thing to do might be an extra
space in your c
fe80::104d:416e:a8dc:c02e %12
Since %12 is a "space" character, it seems first thing to do might be an
extra space in your code. Just a quick guess.
Regards,
Ben Kim
On Mon, 8 Sep 2008, Sofer, Yuval wrote:
Hello,
postgres version: 8.2.0.4
platform windows: server 2008
I check co
Στις Monday 08 September 2008 16:14:29 ο/η Devrim GÜNDÜZ έγραψε:
> On Mon, 2008-09-08 at 11:35 +0800, Jumping wrote:
> > I plan to update my database from 8.1.9 to 8.3.3.
> > Is there any tricks or tips ?
>
> I would first update to 8.1.13, then go on.
Hehe i upgraded from 7.4 to 8.3.3 an
On Mon, 2008-09-08 at 11:35 +0800, Jumping wrote:
> I plan to update my database from 8.1.9 to 8.3.3.
> Is there any tricks or tips ?
I would first update to 8.1.13, then go on.
Anysay, Read the release notes, and check for any possible
incompatibility issues.
http://www.postgresql.org/
Hello,
postgres version: 8.2.0.4
platform windows: server 2008
I check connections using:
SELECT pg_stat_get_backend_idset()
Now, I take the output and try to get the ip addresses using
select pg_stat_get_backend_client_addr();
but for a local connection (simple login us
Hello Peter,
thank you very much for your quick reply again.
> Datum: Thu, 04 Sep 2008 16:43:42 +0300
> Von: Peter Eisentraut <[EMAIL PROTECTED]>
> An: Jan-Peter Seifert <[EMAIL PROTECTED]>
> CC: Postgres
> Betreff: Re: [ADMIN] pg_dump etc. versions
> I think the only thing that we really check
[EMAIL PROTECTED] wrote:
Well - I did setup two instances of 8.3.3 on an Ubuntu 7.10 system last week - both under a different user account. I
set the locale for each account in the .bashrcs ("export LANG=de_DE" and "export LANG=de_DE.UTF-8"
respectively). After that I ran initdb ("initdb --enc
Hello Peter,
thank you very much for your quick reply.
> Datum: Thu, 04 Sep 2008 16:46:33 +0300
> Von: Peter Eisentraut <[EMAIL PROTECTED]>
> An: Jan-Peter Seifert <[EMAIL PROTECTED]>
> CC: Postgres
> Betreff: Re: [ADMIN] server/db encoding (mix) issues
> Jan-Peter Seifert wrote:
> > we have a
13 matches
Mail list logo
