MURAT KOÇ wrote:
> In Oracle, it could be created a user profile called "PROFILE" and this
> profile could have below
> specifications:
>
> PASSWORD_LIFE_TIME (that describes when password will expire)
> FAILED_LOGIN_ATTEMPTS (specifies number of failed login attempts before
> locking user a
2013/3/8 Albe Laurenz
> This way you can also force a certain password expiry date
> (PostgreSQL does not have a password life time).
>
What bout ALTER ROLE ... VALID UNTIL 'timestamp' ?
--
Victor Y. Yegorov
Victor Yegorov wrote:
> 2013/3/8 Albe Laurenz
>> This way you can also force a certain password expiry date
>> (PostgreSQL does not have a password life time).
>
> What bout ALTER ROLE ... VALID UNTIL 'timestamp' ?
That's the password expiry date.
Oracle's concept is different: it sets a limit
For some reason I'm removed all grants and roles from this users
account but I'm unable to remove / drop him from the database as
follows:
postgres=# \du
List of roles
Role name | Attributes
| Member of
---+--
On Fri, Mar 8, 2013 at 4:07 AM, Albe Laurenz wrote:
> Victor Yegorov wrote:
> > 2013/3/8 Albe Laurenz
> >> This way you can also force a certain password expiry date
> >> (PostgreSQL does not have a password life time).
> >
> > What bout ALTER ROLE ... VALID UNTIL 'timestamp' ?
>
> That's the pas
You should alter owner of the functions.
Try "alter function function_name owner to new_owner;
Leif Gunnar Erlandsen
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi folks,
I'm looking for a HowTo of Foreign Tables feature. We are thinking of
connecting two postgres databases via this way and I wanted to try
before I do say yes or no ;) However, I didn't find any good HowTo on
via §search_engine.
Cheers,
Frank
--
Sent via pgsql-general mailing list (pgs
2013/3/8 Frank Lanitz :
> Hi folks,
>
> I'm looking for a HowTo of Foreign Tables feature. We are thinking of
> connecting two postgres databases via this way and I wanted to try
> before I do say yes or no ;) However, I didn't find any good HowTo on
> via §search_engine.
If it's postgres_fdw you'
Good morning,
I am looking for the command to grant create schema permission for a user.
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/08/2013 07:22 AM, Emi Lu wrote:
Good morning,
I am looking for the command to grant create schema permission for a user.
http://www.postgresql.org/docs/9.2/interactive/sql-grant.html
Thanks.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-
We have a stored procedure that takes two integers as parameters, a start date
and a stop date.
It runs some calculations on a table and updates some columns in the same table.
The table being updated is partitioned.
The server version is 9.1.8.
When we run this stored procedure through pgadmi
I got it fixed.
What I did was
$ psql -c "SELECT pg_start_backup('label', true)"
$ rsync -a ${PGDATA}/ standby:/srv/pgsql/standby/ --exclude postmaster.pid
$ psql -c "SELECT pg_stop_backup()"
It took a while a to catch up the data.
One question I have , are there any scripts to monitor the sta
Hello
2013/3/8 Bradley Russell :
> We have a stored procedure that takes two integers as parameters, a start
> date and a stop date.
>
>
>
> It runs some calculations on a table and updates some columns in the same
> table.
>
>
>
> The table being updated is partitioned.
>
>
>
> The server version
I will see if I can strip the code down more to a smaller sample. It is part
of a larger project. Though I have debugged it to confirm on that connection
the only command being sent is the select of the stored procedure.
The strange thing is the time is actually spent running on the server. W
I'm not sure about the existence of any standard scripts, but we have a
pair of checks running periodically on the backup server.
This shouldn't return anything:
tail -3 /var/log/postgresql/postgresql-9.1-main.log | grep FATAL
And this should return something:
ps -u postgres -o cmd | grep "postgr
2013/3/8 Bradley Russell :
> I will see if I can strip the code down more to a smaller sample. It is part
> of a larger project. Though I have debugged it to confirm on that connection
> the only command being sent is the select of the stored procedure.
>
> The strange thing is the time is actu
So I have checked all that stuff several times but what I think I have narrowed
it down to now is I can get the 15 minute run time running the program on my
development desktop but when I put the program on my production server to run
it, I get the 1 hour runtime.
My development box is xp and
https://gist.github.com/joevandyk/070e4728c4c9fe1bf086/raw/8b1ecf4b2d4fd127a22cb19abe948c29d78c2158/gistfile1.txtsummarizes
the problem.
andres on #postgresql says that making #2 use a faster plan shouldn't be
hard, but he doesn't seem #3 happening.
I was surprised about #2 not being faster, andr
Oops, fixing link.
https://gist.github.com/joevandyk/070e4728c4c9fe1bf086/raw/8b1ecf4b2d4fd127a22cb19abe948c29d78c2158/gistfile1.txt
summarizes the problem.
On Fri, Mar 8, 2013 at 4:17 PM, Joe Van Dyk wrote:
>
> https://gist.github.com/joevandyk/070e4728c4c9fe1bf086/raw/8b1ecf4b2d4fd127a22cb19a
On 03/06/2013 07:16 PM, François Beausoleil wrote:
Le 2013-03-06 à 21:42, Tony Dare a écrit :
I'm taking an standard deviation of a population and subtracting it from the
average of the same population and rounding the result. Sometimes that result
is negative and rounding it returns (or show
Thanks a lot. I started the replication. It became very slow. It is taking
long time to sync the masters data onto slave. Is there a way to find
what's causing the issue?
Regards
On Fri, Mar 8, 2013 at 12:06 PM, John Laing wrote:
> I'm not sure about the existence of any standard scripts, but
What I noticed is...
our streaming stopped on march 5th. I restarted the process today.
However the new data is syncing correctly. But the data for these dates
between 5th and today is not syncing. Is there some thing wrong that I did.
here is what I did.
1.. created base backup
2. Took th
22 matches
Mail list logo
