Hi, community members,
on behalf of PgConf Russia local commitee, program commitee and russian
postgresql group I apologize about the issue with including inappropriate
dancers into conference social event. The issue was caused by the lack of
control on the company which was responsible for the
Le 6 févr. 2015 17:31, "Adrian Klaver" a écrit :
>
> On 02/06/2015 05:03 AM, Guillaume Drolet wrote:
>>
>> Hi,
>>
>> Yesterday I ran a pg_basebackup of my cluster. Since it has completed,
>> my cluster doesn't work properly. I tried restarting the computer (or
>> service) a few times but I always
I posted this to pgbugs a little while ago and I couldn't get much
traction. I'm hoping that someone in the general list may be able to
help me with this. Namely, this question:
For contrib functions - is there even a way for embedded queries in
functions to be auto-coded to the correct schema whe
On 02/06/2015 09:17 AM, Guillaume Drolet wrote:
Dear Adrian,
Thanks for helping me. Sorry for the lack of details, I had said to
myself I had to not forget to give these details but I hit the send
button too fast. You know how it is...
I added more info in your reply below.
First some que
David G Johnston writes:
> On Fri, Feb 6, 2015 at 3:41 PM, Felipe Gasper [via PostgreSQL] <[hidden
> email]> wrote:
>
> So, this works when I do it manually, but not when I script it.
>
> Is it possible that this change doesnât take effect immediately? Is
> there any way to tel
On Fri, Feb 6, 2015 at 3:55 PM, Felipe Gasper [via PostgreSQL] <
ml-node+s1045698n5837008...@n5.nabble.com> wrote:
> On 6 Feb 2015 4:51 PM, David G Johnston wrote:
>
> > On Fri, Feb 6, 2015 at 3:41 PM, Felipe Gasper [via PostgreSQL] <[hidden
> > email] >wrote:
> >
> >
> > So, this works when I
On 6 Feb 2015 4:51 PM, David G Johnston wrote:
On Fri, Feb 6, 2015 at 3:41 PM, Felipe Gasper [via PostgreSQL] <[hidden
email] >wrote:
So, this works when I do it manually, but not when I script it.
Is it possible that this change doesn’t take effect immediately? Is
there any way to
On Fri, Feb 6, 2015 at 3:41 PM, Felipe Gasper [via PostgreSQL] <
ml-node+s1045698n5837006...@n5.nabble.com> wrote:
>
> So, this works when I do it manually, but not when I script it.
>
> Is it possible that this change doesn’t take effect immediately? Is
> there any way to tell when it does (besid
On 6 Feb 2015 4:31 PM, Felipe Gasper wrote:
On 6 Feb 2015 4:21 PM, Jerry Sievers wrote:
David G Johnston writes:
On Fri, Feb 6, 2015 at 2:29 PM, Felipe Gasper [via PostgreSQL]
<[hidden email]> wrote:
On 6 Feb 2015 3:15 PM, David G Johnston wrote:
> Felipe Gasper wrote
>> Hell
On 6 Feb 2015 4:21 PM, Jerry Sievers wrote:
David G Johnston writes:
On Fri, Feb 6, 2015 at 2:29 PM, Felipe Gasper [via PostgreSQL] <[hidden email]>
wrote:
On 6 Feb 2015 3:15 PM, David G Johnston wrote:
> Felipe Gasper wrote
>> Hello,
>>
>> Is there a way to tempora
David G Johnston writes:
> On Fri, Feb 6, 2015 at 2:29 PM, Felipe Gasper [via PostgreSQL] <[hidden
> email]> wrote:
>
> On 6 Feb 2015 3:15 PM, David G Johnston wrote:
>
> > Felipe Gasper wrote
> >> Hello,
> >>
> >> Is there a way to temporarily suspend a user account?
>
On 6 Feb 2015 4:04 PM, Michael Nolan wrote:
Encrypted passwords are kept in the pg_shadow file and should start with 'md5'.
Just save a copy of the encrypted password for that user and when you
want to re-enable that user do:
alter user xxx encrypted password 'md5';
I have tested this
Hi List,
Trying to install PostgresSQL 9.4.1 on Window XP Pro Service Pack 3.
Installation is aborted with the following error:
Unknown error while running C:\Documents and Settings\George Weaver\Local
Settings\Temp\postgresql_installer_dc46cfee2c\getlocales.exe
bitrock_installer.log
On 2/6/15, David G Johnston wrote:
> On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] <
> ml-node+s1045698n5836989...@n5.nabble.com> wrote:
>
>> Might not do what you want, but I just change the password.
>>
>>
> How do you do that and re-enable using the previous password?
>
> Davi
Community members:
The PostgreSQL user group in Moscow is currently conducting their
first-ever PostgreSQL-themed conference, which has been a tremendous
success. Unfortunately, the venue booked by the conference chose to
include inappropriate dancers as part of their entertainment package.
The c
On Fri, Feb 6, 2015 at 2:29 PM, Felipe Gasper [via PostgreSQL] <
ml-node+s1045698n5836992...@n5.nabble.com> wrote:
> On 6 Feb 2015 3:15 PM, David G Johnston wrote:
>
> > Felipe Gasper wrote
> >> Hello,
> >>
> >> Is there a way to temporarily suspend a user account?
> >>
> >> I would prefer not to
On 6 Feb 2015 3:24 PM, David G Johnston wrote:
On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] <[hidden
email] >wrote:
Might not do what you want, but I just change the password.
How do you do that and re-enable using the previous password?
Is there no way to “sync up” f
On 6 Feb 2015 3:15 PM, David G Johnston wrote:
Felipe Gasper wrote
Hello,
Is there a way to temporarily suspend a user account?
I would prefer not to revoke login privileges since that will break
things that mine pg_users and pg_shadow.
I also am trying to find somethi
Melvin Davidson writes:
> Possibly,
>
> To disble:
> ALTER USER name RENAME TO xname;
Fine if you don't care about losing password :-)
yomamadb/postgres
=# create user foo password 'foowow';
CREATE ROLE
yomamadb/postgres
=# alter user foo rename to fooxxx;
NOTICE: MD5 password cleared becau
On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] <
ml-node+s1045698n5836989...@n5.nabble.com> wrote:
> Might not do what you want, but I just change the password.
>
>
How do you do that and re-enable using the previous password?
David J.
--
View this message in context:
http:/
Might not do what you want, but I just change the password.
--
Mike Nolan
On Fri, Feb 6, 2015 at 4:11 PM, Melvin Davidson
wrote:
> Possibly,
>
> To disble:
> ALTER USER name RENAME TO xname;
>
> To enable
> ALTER USER xname RENAME TO name;
>
> ???
>
>
> On Fri, Feb 6, 2015 at 3:57 PM, Felipe Gas
> I would prefer not to revoke login privileges since that will break things
> that mine pg_users and pg_shadow.
> Melvin Davidson-5 wrote
>> Possibly,
>>
>> To disble:
>> ALTER USER name RENAME TO xname;
>>
>> To enable
>> ALTER USER xname RENAME TO name;
Given that removing login privileges i
Felipe Gasper wrote
> Hello,
>
> Is there a way to temporarily suspend a user account?
>
> I would prefer not to revoke login privileges since that will break
> things that mine pg_users and pg_shadow.
>
> I also am trying to find something that is completely reversible, so
>
Possibly,
To disble:
ALTER USER name RENAME TO xname;
To enable
ALTER USER xname RENAME TO name;
???
On Fri, Feb 6, 2015 at 3:57 PM, Felipe Gasper
wrote:
> Hello,
>
> Is there a way to temporarily suspend a user account?
>
> I would prefer not to revoke login privileges since
Hello,
Is there a way to temporarily suspend a user account?
I would prefer not to revoke login privileges since that will break
things that mine pg_users and pg_shadow.
I also am trying to find something that is completely reversible, so
something like setting connection limit to
On Friday, February 6, 2015, Adrian Klaver
wrote:
> On 02/06/2015 10:26 AM, Tim Smith wrote:
>
>> Re:So, you have an input parameter named "session_id" and a query with
>> a column named "session_id" - this is the problem.
>>
>> Well, I'll re-try with a revised function, but surely the database
>
On 02/06/2015 10:26 AM, Tim Smith wrote:
Re:So, you have an input parameter named "session_id" and a query with
a column named "session_id" - this is the problem.
Well, I'll re-try with a revised function, but surely the database
could have come up with a more meaningful and insightful message t
Thank you Adrian. Will give this a go over the weekend.
On 6 February 2015 at 17:23, Adrian Klaver wrote:
> On 02/06/2015 08:55 AM, Tim Smith wrote:
>>>
>>> Unfortunately the function definition is not given and that is where you
>>> are seeing the error.
>>> To figure this out we will need to se
Re:So, you have an input parameter named "session_id" and a query with
a column named "session_id" - this is the problem.
Well, I'll re-try with a revised function, but surely the database
could have come up with a more meaningful and insightful message than
the coded incomprehensible error messag
On Fri, Feb 6, 2015 at 10:23 AM, Adrian Klaver
wrote:
>
>> CREATE FUNCTION validateSession(session_id char(64),client_ip
>> inet,user_agent char(40),forcedTimeout bigint,sessionTimeout bigint)
>> RETURNS json AS $$
>>
>
> CREATE OR REPLACE FUNCTION public.validatesession(s_id character,
> clien
On 02/06/2015 08:55 AM, Tim Smith wrote:
Unfortunately the function definition is not given and that is where you are
seeing the error.
To figure this out we will need to see the function.
Geez, there's just no satisfying some people ! ;-)
I did actually show you my function in an earlier ma
On Fri, Feb 6, 2015 at 9:55 AM, Tim Smith
wrote:
> >Unfortunately the function definition is not given and that is where you
> are seeing the error.
> > To figure this out we will need to see the function.
>
> Geez, there's just no satisfying some people ! ;-)
>
> I did actually show you my func
Dear Adrian,
Thanks for helping me. Sorry for the lack of details, I had said to myself
I had to not forget to give these details but I hit the send button too
fast. You know how it is...
I added more info in your reply below.
2015-02-06 11:28 GMT-05:00 Adrian Klaver :
> On 02/06/2015 05:03 AM
>Unfortunately the function definition is not given and that is where you are
>seeing the error.
> To figure this out we will need to see the function.
Geez, there's just no satisfying some people ! ;-)
I did actually show you my function in an earlier mail but my
current bodged minimised
On 02/06/2015 05:03 AM, Guillaume Drolet wrote:
Hi,
Yesterday I ran a pg_basebackup of my cluster. Since it has completed,
my cluster doesn't work properly. I tried restarting the computer (or
service) a few times but I always get the same messages in my logs (it's
in French. If someone is willi
On 02/06/2015 05:33 AM, Tim Smith wrote:
Nice work-around Marc. Thank you !
Nice that it works, but in the end it proves that the issue is not with
row_to_json and a row type, but with how %ROW_TYPE is being used in a
specific function. To prove it, using your earlier function modified for
On 02/06/2015 04:19 AM, Tim Smith wrote:
Alright then, here you go ... Postgres 9.4
We start with a clean database :
json_return_debugdb=> \dn
List of schemas
Name | Owner
+--
public | postgres
(1 row)
json_return_debugdb=> \dt
No relations found.
json_return_debugdb=
Perhaps, I do not fully understand completely, but would it not be simpler
to just rearrange the key (and partition) by date & location?
EG: 2015_01_01_metrics_location_X
In that way, you would only have 365 partitions per year at most. But you
also have the option to break it down by week or
Nice work-around Marc. Thank you !
On 6 February 2015 at 13:01, Marc Mamin wrote:
>
>>Von: pgsql-general-ow...@postgresql.org
>> [pgsql-general-ow...@postgresql.org]" im Auftrag von "David Johnston
>> [david.g.johns...@gmail.com]
>>Gesendet: Freitag, 6. Februar 2015 00:38
>>An: Tim Smith
>>Cc: A
Hi,
Yesterday I ran a pg_basebackup of my cluster. Since it has completed, my
cluster doesn't work properly. I tried restarting the computer (or service)
a few times but I always get the same messages in my logs (it's in French.
If someone is willing to help me I can try to translate the logs. Jus
>Von: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org]"
>im Auftrag von "David Johnston [david.g.johns...@gmail.com]
>Gesendet: Freitag, 6. Februar 2015 00:38
>An: Tim Smith
>Cc: Adrian Klaver; pgsql-general
>Betreff: Re: [GENERAL] Using row_to_json with %ROWTYPE ?
>On Thu,
And if you want my exact version of Postgres its "PostgreSQL 9.4.0 on
x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit" (taken from the Postgres APT
repository)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
Alright then, here you go ... Postgres 9.4
We start with a clean database :
json_return_debugdb=> \dn
List of schemas
Name | Owner
+--
public | postgres
(1 row)
json_return_debugdb=> \dt
No relations found.
json_return_debugdb=> \dv
No relations found.
We replicate a ba
43 matches
Mail list logo
