4/main/"%p"'
Ok, but those instructions are for 9.1 not for 8.4, I would like to be
sure if there is any way to perform countinus archiving then recovery
then backup and loop over this every day whithout having to rsync every
time I recover the standby database (8.4)
Slds
--
Typed
On 07/17/2013 03:05 AM, chiru r wrote:
> Hi Nestor,
>
> So the question is: Can I have some continues wal archiving and then
> transfer all WAL files to *standby* everyday, recover the database and
> backup all data without having to rsync the data every time i make a
> backup
Hello People,
In reference to my last post
<http://www.postgresql.org/message-id/[email protected]>
, my question is: It is possible to recover more (subsequent) WAL files
when I have already recover a postgres 8.4 database using a PITR ? I
have read on some places that it
Hello People,
I need some clarification on Continuous Archiving and Point-In-Time
Recovery (PITR).
I have been able to replicate a postgresql 8.4 database from one machine
to another using rsync and wal files.
I do this as follows (Using debian gnu/linux squeeze):
In *master* i have the
Hi,
I have a read heavy application. I would want it to read from memory as
database latency has to be in low milliseconds.
The database is not too big in size and can be fully contained in memory.
With Postgres, if I cache all the tables (by pre-emptive querying such as
select * from tables
What are the key benefits of using hstore over simple K:V storage in Postgres
where you split the key in its own column and value in its own column ?
Thank you for any inputs.
In FTS, how do I search for partial substrings that don't form a English word.
Example, in the text: 'one hundred thirty four' I want to find the records
based on 'hun'
SELECT to_tsvector('one hundred thirty four') @@ to_tsquery('hun');
does not return anything.
Thanks.
elves? If not, did you terminate them yourself? How? With a
> signal (kill)? Which signal? Some other way?
>
Just /etc/init.d/postgresql-9.0 restart
As far as I know it uses "smart" shutdown on debian.
> > Postgres restarted successfully, but the database became
> > u
Why have you decided it isn't using indexes?
If index exists - postgres will use it.
To write a script for this I need at least database version.
On Wed, 09 Nov 2011 16:22:20 +0100
Silvio Brandani wrote:
> Our database seems not using index anymore, please help with, is a
>
No, this was a clean install of 9.0.x.
Maybe It was upgraded from 9.0.3 to 9.0.4. I'm not sure.
On Wed, 09 Nov 2011 09:21:18 -0600
"Kevin Grittner" wrote:
> "Ruslan A. Bondar" wrote:
>
> > ERROR: could not access status of transaction 15892843
> >
There were no unexpected reboots.
First issue was some kind of deadlock (concurrent insert and concurrent delete
on a table) I saw them wile reindexing the database.
Also mesages like this were in dmesg:
[3681001.529179] INFO: task postgres:12432 blocked for more than 120 seconds
Hello all.
This is a first time I receive such an issue.
My database was corrupted some way.
When I'm trying to access the database via psql I receive:
root@udb:/etc/bacula# psql -U bacula
psql: FATAL: could not read block 0 in file "base/16387/86057840": read only 0
of 8192 by
So I assume there is no redundant information stored such as checksum to
validate the files against the stored checksums.
I don't have an active issue. Just trying to understand in detail how Postgres
behaves under index corruption.
From: Craig Ringer
To
How does Postgres detect corruption of index data files ? What is the exact
mechanism by which it knows that the index is corrupt ? Can it happen that part
of the index is corrupt but Postgres does not realize because those specific
rows are not accessed (but other rows from that table are acces
What are the various ways in which I can validate that a standby (new or
existing) is caught-up with the master ? For streaming replication setup in v9.x
Hello
I am running a test to find the impact of corrupt indexes on queries. I
corrupted the index file but observed that the queries continued to perform
without issues. It was only on restart of the database that postgres realized
that the indexes are corrupt and my queries started failing
Couple of questions:
1. At what frequency is the archive_cleanup_command executed from the
recovery.conf file on the standby ?
2. If for some reason lets say a WAL file is missing from the archive directory
but the files after that are present. When the standby tries to restore the
missing WAL
.
From: A J
To: PG Admin
Sent: Wednesday, August 10, 2011 12:41 PM
Subject: Cleanup of same archive used by multiple standbys
What is the suggested technique for cleaning up an archive location shared by
multiple standbys. Looks like pg_archivecleanup cannot be used as %r refers to
What is the suggested technique for cleaning up an archive location shared by
multiple standbys. Looks like pg_archivecleanup cannot be used as %r refers to
last restartpoint of only a single standby server.
Do I need to create a custom script that somehow determines the latest common
What are the tentative release dates of 9.1 and 9.2 versions ?
Thanks.
I am trying to see the impact of commit_delay.
Set it to 10 (microseconds), i.e. to 100ms
synchronous_commit is kept to default (i.e. ON)
Now I expect my DML statements to take atleast 100ms. But when I try to execute
a few and measure using the timing command of postgres or the time command
Does a synchronous_commit force WAL to be committed to disk or does it just
WAIT for WAL to be committed according to WAL's set frequency to write ?
i.e. if I set wal_writer_delay=200ms and set synchronous_commit=on, will each
commit wait for upto 200ms before committing ?
storage). So in a typical setup, you always risk loosing
up-to 16MB of committed data at failover. Right ? And I assume there is no way
to reconcile this 16MB automatically when the crashed ex-primary server comes
up again. Right ?
3. I don't think 'wal_keep_segments' has too much of
I am still not clear. Can you explain what replication_timeout parameter
accomplishes and when ?
Basically I wish my synchronous write transaction to not wait indefinitely when
the synchronous standby servers are not available. But rather a response
returned back to client that write could not
On 9.1, Beta3 I set the following on master
replication_timeout = 10s # in milliseconds; 0 disables
With no slaves running, I expect a failure in about 10s. But any Insert just
hangs. Any idea ?
Thanks.
Couple of months back, Josh Berkus posted an issue with promotion of the
standby in Streaming replication. Subject 'Standby promotion does not work' in
the pgsql-hackers forum.
It seemed that during failover, it was not possible to repoint the rest of the
slaves to the new master. Is this resolv
I understand that 'cluster' performs the role of defrag (along with rewriting
in index order) in Postgres.
How frequently does one have to run cluster ? Any thumb-rules or experience ?
How do I find if my table is fragmented enough to need a cluster ?
We are still to use Postgres in
Hello
Having a master and 2 slaves in synchronous replication mode in 9.1
The master seems to wait for only one slave to respond before considering the
transaction to be complete. I have done the setting for master to wait for all
the slaves to finish:
synchronous_standby_names = '*&#x
Ok. So if I understand it correctly, as far as Postgres is concerned the
'mirror
is broken'. It is a one-time cutover.
We then rely on filesystem tools (or other third party tools) to get the
original master in sync with the new master efficiently and then make it join
as
sl
>>To return to normal operation, a standby server must be recreated, either on
>>the
>>former primary system when it comes up<<
What does it exactly mean to 'recreate a standby server' ? Can I not use the
datafiles on the former primary and just let it sync
Hello,
I am trying to switch the master and slave roles in a test I am doing with
streaming replication in 9.1 beta.
To start with, I have one master (N1 node) and one slave (N2 node).
I stop N1 and promote N2 as primary (by touching the trigger file).
Now I wish for N1 to come back up as slave
Hello.
I'm running 8.4 and with a backup procedure of
pg_start_backup()
copy base backup
pg_stop_backup()
The backup script failed and the pg_stop_backup command were killed so
now the pg_xlog/ directory has some extra
xx.backup files
and in the archive_status/ directory I hav
Hello.
I just wanted to check with you, the experts, on what directories to
include in the basebackup (following
http://www.postgresql.org/docs/8.4/static/continuous-archiving.html)
I should include these:
base/
global/
pg_clog/
pg_multixact/
pg_stat_tmp/
pg_subtrans/
pg_tblspc/
pg_twophase/
PG_
Hello.
Is it possible to copy archived WAL files and a base backup from a 64
bit CentOS enviroment to a 32 bit CentOS environment and get the
database up and running on the 32 bit machine by using the base backup
and the WAL files?
--
Sent via pgsql-admin mailing list ([email protected]
Hello.
In the docs of 8.4 I read that one way of doing filesystem backup of
PostgreSQL is to
1. run rsync
2. stop the server
3. run second rsync
4. start server
But what would happen if you
1. run rsync
2. throw server through the window and buy new server
3. copy the rsynced data
4. start server
Does anyone know of a module for postgres that can do metadata management in
postgres but actual storage of binary objects in filesystem ?
Not really using Postgres large object but want to just do the metadata
management with postgres. Example, need to store file
name/size/directory/drive/node
Hello,
I am planning to have a postgres database for large object storage. I believe
that with version 9.0, the 'world readable' issue with pg_largeobject is
resolved and we can now control at object level- which users can read/write
what
objects.
Streaming performance is an issue
During restore of a database (from a full backup), the general practice is to
rebuild the indexes. I think with pg_dump and pg_restore (or psql restore), the
only option is to rebuild the indexes. Am I right or is it possible to backup
indexes as well and restore them ?
Just exploring, to
That would explain it. I was neither in a transaction nor did any explicit
HOLD.
Thanks Kevin.
From: Kevin Grittner
To: [email protected]; A J
Sent: Mon, October 4, 2010 5:20:14 PM
Subject: Re: [ADMIN] ECPG: AUTOCOMMIT and CURSORs
A J wrote:
>
I am seeing some funny behavior on using both:
EXEC SQL SET AUTOCOMMIT TO ON;
and
CURSORS (EXEC SQL DECLARE ., EXEC SQL FETCH NEXT FROM .)
On autocommit on (either through above method or precompiling with -t option),
the cursor does not return any rows. On disabling autoc
Just to give an update, changing pg_log to a different drive that is write
cache
enabled (and to further make it fast, kept it data=writeback), helped quite a
bit.
The average time for several clients hitting concurrently was 15ms each for
east-coast as well as west-coast clients. Still some
PostgreSQL 8.4
CentoOS 5.5
I have got WCE=0, on the drive that mounts the data directory with all its
subdirectory (including pg_log)
Maybe I should try to mount pg_log to a different drive and have write cache
enabled on that one.
From: Tom Lane
To: A J
Sorry, forgot to mention that:
logging_collector = on # Enable capturing of stderr and csvlog
Infact I was thinking of the other way, to switch it off and somehow display
the
stderr(or syslog) directly on console (rather than writing to a file) to see if
it helps
ation to syslog may make a difference (Kevin
mentioned even this timing is not totally immune from network effects but if
possible to measure should be very close to the query time) ?
From: Kevin Grittner
To: Scott Marlowe ; A J
Cc: pgsql-admin@postgresq
files equal or larger
#log_timezone = unknown # actually, defaults to TZ environment
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
___
Kevin
The problem I am trying to solve is:
measure accurately both the database server time + network time when several
clients connect to the database from different geographic location.
All the clients hit the database simultaneously with a long script each of
insert/update/select queries.
I
I am conducting the test with several concurrent clients.
The problem I am now facing in using log_min_duration_statement is that all the
clients have to write to a single log file in the pg_log directory. So they
have
to wait for the other writes to happen before completing their write. This
.
From: Kevin Grittner
To: [email protected]; A J
Sent: Tue, August 31, 2010 2:14:27 PM
Subject: Re: [ADMIN] Confused by 'timing' results
A J wrote:
> time echo '\timing \\select * from table1 where id = 123;' | psql
&g
time echo '\timing \\select * from table1 where id = 123;' | psql
I am trying to time a simple select statement from different clients located at
different places. The database is on US east-coast.
In the above query. the 'timing' will time the database time and the 't
Cost aside, are there any technical factors to consider before increasing RAM
(assuming the system can support it) ? Is there a sweet spot beyond which more
RAM does not help Postgres or actually harms ?
If my database is only couple of hundred Gigs, can I not just have RAM that big
and have
>> but #1 was focused on backing up MyDatabase that resides on
>> /hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.
>Do you already have the backup you want to restore? If so, how was
>it made, exactly?
Yes.
I used pg_dump to make the backup.
No cluster here, it is just a stand alone db server. Sorry if I sent this to
the
wrong UG.
I have #2 down already; but #1 was focused on backing up MyDatabase that
resides
on /hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.
From: Kevin Grittner
Good day all,
I am fairly new with PQSQL and am slowly picking things up - I have added a new
disk and would like to do two things:
1. Restore a backup to this new disk - /hda2/pgdata/
2. Move a database from /hda1/pgdata to /hda2/pgdata/
Any help is most appreciated, thank you.
На 05.4.2010 23:11, Kevin Crain написа:
[...]
Also is there a way to limit the number of concurrent connections on a per
account basis?
ALTER ROLE CONNECTION LIMIT ;
(http://www.postgresql.org/docs/current/static/sql-alterrole.html)
--
Milen A. Radev
--
Sent via pgsql-admin mailing list
On Fri, 2010-03-05 at 17:39 -0500, John A. Sullivan III wrote:
> On Fri, 2010-03-05 at 14:13 -0800, Bob Lunney wrote:
> >
> > --- On Fri, 3/5/10, John A. Sullivan III
> > wrote:
> >
> > > From: John A. Sullivan III
> > > Subject: [ADMIN] Quer
On Fri, 2010-03-05 at 14:13 -0800, Bob Lunney wrote:
>
> --- On Fri, 3/5/10, John A. Sullivan III
> wrote:
>
> > From: John A. Sullivan III
> > Subject: [ADMIN] Querying the same column and table across schemas
> > To: [email protected]
> >
On Fri, 2010-03-05 at 19:59 +, Daniel J. Summers wrote:
> On 03/05/2010 07:44 PM, John A. Sullivan III wrote:
> > I'm trying to avoid making a thousand call like
> >
> > select user1.session_id from user1.sessions;
> >
> > when I could do it in a single
Hello, all. I'm working on a project using the X2Go terminal server
project (www.x2go.org). They record session data in a postgresql
database. Our environment is a little more secure than typical and we
do not want it possible for one user to see another's session data. We
thus ha
Hello,
Can anyone please throw some light on the behavior of postgres when it comes
to permission issues... I'm using enterprisedb 8.3 on opensuse linux 10.3
and 11 (2 machines).
This is what i have understood so far:
Lets say user user1 is a non-root user. I login to the machine as
Secondly this is not the right group to address such problems. This is an
sql-syntax related issue. You should address this question to
[email protected] or better still, [email protected].
Thanks,
Shruthi
On 12/28/09, Shruthi A wrote:
>
> On 12/28/09, Premila Devi
us.name;
>
> ERROR: syntax error at or near "group"
>
I think you've got several parts of the syntax wrong here. Looking at your
query, we cannot even figure out what are the structures of your tables and
what is it that you are trying to get out of your query. I am guessi
Hi,
The page
http://www.postgresql.org/docs/7.2/static/datatype-datetime.htmlmentions
that the resolution of all time and timestamp data types is 1
microsecond. I have an application that runs on both a Windows (XP with
SP2) machine and a Linux (SUSE 10.2) machine. I saw that on postgres
still confused why local ident
authentication works even without a running ident server, though. Does
anyone know why that is?
If by "local ident" you mean "when connecting thru unix-domain
sockets" then read here:
http://www.postgresql.org/docs/current/static/auth-methods.h
Wow! Thanks a lot! That was a great deal of help! :-)
On Wed, Nov 18, 2009 at 8:41 PM, Jure Kobal wrote:
>
> > -- While running the pgagent daemon, what dbname should i specify? Is it
> > postgres or pgadmin (as the example in
> >
> http://www.enterprisedb.com/docs/en
Thanks,
This pgagent seems to be a good interactive tool. I tried using it, but i
ran into some problems and extensive search didnt yield enough help or
documentation on this. This is a brief list of my doubts.
-- I connected to the 'postgres' database in my pgAdmin and ran the
p
Shruthi A написа:
> Hello,
>
> Is it possible in postgres to write a trigger that is fired at a certain
> pre-defined time? ie I want to write a trigger that checks if the current
> time is one of a certain list of dates, and if yes, it should be executed.
> (I want it to exec
Hello,
Is it possible in postgres to write a trigger that is fired at a certain
pre-defined time? ie I want to write a trigger that checks if the current
time is one of a certain list of dates, and if yes, it should be executed.
(I want it to execute only once on a matching date.)
I'm
Hello,
I guess you a bit lucky here. I worked on exactly the same problem for a
requirement in my project. And i've winded it up just today. I'm using
Java for my application, but i'm doing this particular task outside Java,
using shell directly. (It is a 3-line shell script)
Hi all,
Thanks a lot for all your replies. The problem is solved now. This is the
correct thing to do:listen_addresses = '*'
And then restart the service.
Additional notes:
-- Remember to use single quotes around the * else it will give syntax
error.
-- The listen_addresses
Hi,
I want a postgres client to be able to connect to a postgres sever on a
remote machine. But i'm not able to make it work. Assume both the machines
are on a LAN 10.0.0.* .Following available advice, this is what i did:
-- In pg_hba.conf, i added the line
host all all 10.0.0.1/24
Carol Walter написа:
> Hello,
>
> I am creating an application in PHP that accesses a Postgres database.
> This application works, but I have been unable to perform a database
> task that is extremely important. My application is a admin app that
> allows a user to insert re
ges
> JOIN dbmail_messageblks ON
> (dbmail_messages.physmessage_id=dbmail_messageblks.physmessage_id)
> WHERE dbmail_messages.message_idnr='${MSG_UID}'
> GROUP BY dbmail_messages.message_idnr"
>
> It should simply return the whole message which can be truncated to
> pie
gt; ZEILE 1: CREATE TABLE messageblks like dbmail_messageblks;
> ^
>
> What's my error?
Should be "CREATE TABLE messageblks (like dbmail_messageblks);"
--
Milen A. Radev
--
Sent via pgsql-admin mailing list ([email protected])
To
ostgresql.org/docs/current/static/sql-grant.html#SQL-GRANT-DESCRIPTION-OBJECTS).
--
Milen A. Radev
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
> Here is mine and yes I have gotten a lot of flack over it. What is the
> problem with trying to promote your faith and why do so many people have
> problems with it?
I have not looked into exactly what you claim to believe, but
generally: the problem is that the thing you are promoting
Cliff Pratt написа:
[...]
> You should be able to knock up a simple script in bash, perl or python
> to do what you want.
>
> Sort of like:
>
> Use 'psql' to get a list of the databases
> Sanitize the list.
> Loop through the list doing backup.
> At the end z
AmitKumar Jain написа:
> Hi,
>
> 1. Could any one please suggest me that how can I see the details of
> function through psql prompt.
[...]
\df+
(http://www.postgresql.org/docs/current/static/app-psql.html)
--
Milen A. Radev
--
Sent via pgsql-admin mailing list (pgsql-admin@po
tring.html
On second reading of your post (and the documentation) we are both wrong
- the _string_ concatenation operator works when at least one of the
operands is a string.
>
>> -Original Message-
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] On Behalf Of
> new behavior, although I believe this is a bug.
http://www.postgresql.org/docs/current/static/release-8-3.html#AEN86272
--
Milen A. Radev
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Tim Gustafson написа:
> Hello,
>
> I currently have a old GForge installation running on Postgres 7.4.19.
> GForge relies on the OID columns of their application tables for different
> things. I'm trying to upgrade Postgres to 8.2, and in order to do so, I'm
> d
Isabella Ghiurea написа:
> I'm writing a shell script to run analyze and other jobs as use
> postgres, having issues passing the passwd in psql is always asking for
> password, I'm using .pgpass file as argument in psql ( I understood
> PGPASS is depreciated). My .pgpass
Vladimir Rusinov wrote:
May be you have log_min_messages = debug?
Please, show full logging section.
I don't explicitly set that parameter in my config. The full config
file can be found at http://www.antibodymx.net/postgresql.conf
Thanks
--
Martin A. Brooks | http://www.antibodym
Guillaume Lelarge wrote:
Martin A. Brooks a écrit :
I _want_ the stats, however I _only_ want the stats for queries taking
over 5 seconds.
Well, AFAIK, you can't.
Then that would seem to entirely negate the point of having the
log_min_duration_statement option, from what
Guillaume Lelarge wrote:
Martin A. Brooks a écrit :
However, in the log files, I'm seeing entries for all SQL executed, not
just that taking 5000ms or more. For example:
2008-10-14 10:15:50 BST PID:20349 DB:vhdb LOG: statement: select * from
vendors;
2008-10-14 10:15:50 BST PID:
itten,
buffer hit rate = 100.00%
! Local blocks: 0 read, 0 written,
buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Am I missing something obvious?
Regards
--
Martin A. Brooks | http://www.antibodymx.net/ | Anti-spam &
Carol Walter написа:
> Hello,
>
> Does anyone know what the format of hex characters for postgres are?
> I'm trying to create files that contain a 0x55. It looks to me like it
> should require a delimiter of some sort between the characters. I don't
> know how
On Mon, 2008-09-22 at 17:06 +0200, Tino Schwarze wrote:
>
> As far, as you do not really use SIGKILL (9), but SIGTERM (15),
> everything should be fine.
Yea my bad -- SIGTERM not SIGKILL.
Thanks for confirming.
A nice little SQL macro would be awesome: DISCONNECT or TERMINATE
But ha
This one really isn't in the docs, so we'll add it to the Wiki
afterwords, but:
We've got some shared PG instances with more than one production
application (yes, I know this is a bad practice, but virtualization
options are hit and miss).
We need to kill apache P-conn
Carol Walter написа:
Hello,
I've had trouble several times when granting permissions on tables when
I had not also granted permission to the sequence. The sequences may
only have select, insert, and usage privileges. I can guess that when I
grant select privileges on a table, I ne
Campbell, Lance написа:
Is there a list somewhere of the system catalog tables and examples of
querying it for administrative reasons?
[...]
http://www.postgresql.org/docs/current/static/information-schema.html
http://www.postgresql.org/docs/current/static/catalogs.html
This mostly means you
Rafael Domiciano написа:
Hi folks,
I'm new in this mailing list.
I need to create a role (Postgres user) that cannot drop or create table,
but can create TEMP tables. This role must do I, U and D normally.
I have read some docs over the web and discovered that option to revoke
"cr
Milen A. Radev написа:
John DeSoi написа:
On Jun 2, 2008, at 3:19 PM, Kevin Grittner wrote:
Any chance of going to 8.3?
http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html
But 8.3 still does not generate UUIDs, only stores/compares them. From
the link above:
PostgreSQL
3 needed
options where it would be huge code bloat to include sufficient
alternatives?
http://www.postgresql.org/docs/8.3/static/uuid-ossp.html
--
Milen A. Radev
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org
Denison Wright написа:
Hi,
I had a command that I used with Postgresql 8.2 that stopped working once I
upgraded to 8.3.
I am running Postgresql 8.3 on Windows Vista with the following basic
configuration:
- database: mydb
- user: mydbuser
- password: mydbpassword
Mario Splivalo написа:
I need to check, from a bash script, if certain database exists in a
postgres cluster. When I issue:
psql -U someuser somedatabase
psql returns error code 2 regardless of 'no user' or 'no database'
condition. How could I distinguish from the two?
[may be more nagiosplug-devel@ related, but hey!]
It probably wouldn't be a bad idea to include some checkcommands.conf
templates and example service or hostgroup examples. See below.
Templates
define command {
command_namecheck_postgres_size
command
.
--
Milen A. Radev
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Peter Kovacs написа:
[...]
BTW, I had a bookmark for a good tutorial on explain analyze, but the
page is no longer available:
http://www.pervasive-postgres.com/instantkb13/article.aspx?id=10120 .
Can you suggest a good tutorial?
I'm not sure what was the tutorial at the above URL but this
Next time please devise a more informative subject for your inquiry.
--
Milen A. Radev
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
I recently searched for a way to grant permissions to a new created user for
all tables in a scheme or database. I just found ways who uses psql and
scripts. But I'm astonished that there is no way to do it with the "grant
all on database [schema]..."-option. Actually i thought th
1 - 100 of 351 matches
Mail list logo
