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 account)
2013/3/8 Albe Laurenz laurenz.a...@wien.gv.at
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 laurenz.a...@wien.gv.at
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:
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 laurenz.a...@wien.gv.atwrote:
Victor Yegorov wrote:
2013/3/8 Albe Laurenz laurenz.a...@wien.gv.at
This way you can also force a certain password expiry date
(PostgreSQL does not have a password life time).
What bout ALTER ROLE ... VALID
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
2013/3/8 Frank Lanitz fr...@frank.uvena.de:
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
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
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
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 status
Hello
2013/3/8 Bradley Russell bradley.russ...@npcinternational.com:
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.
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.
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
2013/3/8 Bradley Russell bradley.russ...@npcinternational.com:
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
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
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,
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 j...@tanga.com wrote:
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
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 john.la...@gmail.com wrote:
I'm not sure about the existence of any
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
22 matches
Mail list logo
