Hello Lukas,
You would be able to achieve it using the alter user command as given below:
alter user with CONNECTION LIMIT 2;
Lukas wrote:
Hello,
is here any way to set connection limit to database per database user?
For ex. if I have postgresql database user XXX I want limit it to 2
conne
If you are writing Bash script capture the return value of pg_database_size
function, in some variable and perform vacuum.
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
On 05-Apr-2010, at 9:38 AM, Nilesh Govindarajan wrote:
> On 04/05/10 08:54, Scott Marlowe wrote:
_terminate_backend() function.
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
Mob: +91-9011042623
Web:www.EnterpriseDB.com
is not set
In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET
ALL; SET SESSION AUTHORIZATION DEFAULT'
Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'
--
Thanks& Regards,
Vibhor Kumar.
Senior System Engineer.
EnterpriseDB
<http://www.enterprisedb.com/products/pgbindownload.do> of the binaries,
without the installer.
...
Following is a link:
http://downloads.enterprisedb.com/postgresql/postgresql-8.4.4-1-windows-binaries.zip
--
Thanks & Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Comp
Following query would help you:
select inhparent::pg_catalog.regclass, inhrelid::pg_catalog.regclass from
pg_inherits;
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
On Aug 5, 2010, at 7:11 PM, Kevin Kempter wrote:
> Hi All;
>
> can anyone point me to a sys
ment. Setting this parameter, postgresql will write the
SQL in postgresql log files.
For more information, follow the link given below:
http://www.postgresql.org/docs/8.4/static/runtime-config-logging.html#GUC-LOG-STATEMENT
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
http://www.slony.info/downloads/
Or
If you have installed postgreSQL 84 using One-CLick Installer, then using
stackbuilder you would be able to download the slony
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
Web:www.EnterpriseDB.com
--
Sent via pgsql-ad
*' .
>
>
> seems that the use of the -n flag requires to use these schema names within
> the patterns ...
By default tablename without namespace get search in Public Schema.
Please try something like this
pg_dump -i -v -n -T '*.2008*'
Thanks & Regards,
*' .
>
>
> seems that the use of the -n flag requires to use these schema names within
> the patterns ...
By default tablename without namespace get search in Public Schema.
Please try something like this
pg_dump -i -v -n -T '*.2008*'
Thanks & Regards,
s, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t
> LEFT OUTER JOIN pg_proc p
Seems you are using connectors of PG8.4.4 with PG9.0
tgisconstraint column is no more part of pg_trigger table of PG9.0
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftifi
h 8.4.1 then, no need to.
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
DB2 Certified
ITIL V3 Cerftified.
Web:www.EnterpriseDB.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
data into a table
> but how can i find this key and delete it?
>
> thanks
I think error message itself is giving the information of item_id=230
Since parent table "document_director" does not have this value therefore it's
not allowing to insert the values in tab
quences on New Master using
Following command:
SELECT pg_catalog.setval('', , true);
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Feb 4, 2011, at 11:30 PM, Joby Joba wrote:
> in order to reduce disk space used by postgresql's archived logs I use the
> following command for the parameter archive_command :
> archive_command = 'gzip -c %p >/u10/pgmi/postgresql/archive/%f.gz'
> I have configured a standby database with the c
On Feb 24, 2011, at 5:29 AM, H S wrote:
> no read up and no write down policies in BLP model, what sort of queries/
> statements in SQL are read and write!?
READ: SELECT
WRITE: UPDATE/DELETE
Thanks & Regards,
Vibhor
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make cha
On Mar 1, 2011, at 1:23 PM, Gnanakumar wrote:
>
> PostgreSQL Versioning policy says: "Upgrading to a minor release does not
> require a dump and restore; merely stop the database server, install the
> updated binaries, and restart the server."
Install the Binaries of Specific Minor Release and
On Mar 1, 2011, at 3:20 PM, A B wrote:
>
> 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
> now, what would happen?
> I guess the server would think: uh-oh, it has crashed, I'll try to fix it.
This
e drop down.
Edit Data.
1. Right Click on table -> view data option.
Please note Edit Grid is only for tables which primary key or any constraint
which can uniquely identify each row.
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http://vibhork.blogspot.com
--
Sent via pgs
my
> own app. All the credentials are ok, there is no NAT (it's LAN),
> firewall or antivirus.
Please share error message, which you are getting while adding server in
pgAdmin.
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http://vibhork.blogspot.com
--
Sent via
On Mar 5, 2011, at 3:29 AM, Prabhjot S. Sheena wrote:
> skytools-90-2.1.11-1.rhel5.x86_64
http://yum.pgrpms.org/9.0/redhat/rhel-5-x86_64/
http://pgfoundry.org/frs/download.php/2872/skytools-2.1.12.tar.gz
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http://vibhork.blogs
, manuals, and so on
You can use views to implement such type of security.
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
password when prompted?
Include following in dos script.
set PGPASSWORD=
Or you can use pgpass.conf file option.
> 3. Is there a way of running the pg_dump with a user that doesn't have a
> password?
For that user, you have to mention trust with hostname in pg_hba.conf
Thanks
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ny Replication, which
replicate data from mater to slave and also, gives ability to create temporary
table, without allowing user to tamper/modify the data of Replicated Tables of
(Master).
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http://vibhork.blogspot.com
--
Sent via
s,
>
> Fredy Khan
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
on of pg_dump and pg_restore, you can use following command:
pg_dump --version
pg_restore --version.
Thanks & Regards,
Vibhor.
On Apr 12, 2011, at 4:13 PM, Fredy Khan wrote:
> Well please find attached here the error details
>
> On Mon, Apr 11, 2011 at 9:35 PM, Vibhor Kumar wrote:
>
The primary's identifier is
> 5592072752411433371, the standby's identifier is 5597615802844953578.
>
> PostgreSQL Version: 9.0.2
How did you setupt the replication? Please mention the steps. It seems you have
not used the PITR Backup of Primary for creating standby.
Tha
lient_port to
find the informaiton of client machine.
Thanks & Regards,
Vibhor Kumar
vibhor@gmail.com
Blogs: http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
PITR would help you.
Thanks & Regards,
Vibhor Kumar
Blogs: http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
L.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
and is in waiting state. Also
looked at pg_locks for more information on locks.
Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.p
You can use Migration Tool kit or xDB Replication solution from Oracle to
PostgreSQL.
http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51.htm#P6096_508028
Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpr
to configure and provides GUI mode to monitor your replication etc. I did many
migration from Oracle Production database to PostgreSQL. Getting long downtime
window for Production is the main issue I have seen for crucial customer facing
applications.
Thanks & Regards,
Vibhor Kumar
Blogs:http://
34 matches
Mail list logo
