" as developement server?
> Could I have some compatibility problems?
>
> Best Regards,
> André.
>
It won't be problematic to use as a dev server or as a prod server also. You
won't face any compatibility problems.
Abbas.
gt; see also createdb --help for options ...
>
>
> Cheers
>
> Andy
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
If you don't need the password authentication you have to edit the
pg_conf file and replace "password" with "trust", after this reload the
cluster. It won't prompt you for password.
Thanks,
Abbas.
On Wed, Jul 8, 2009 at 4:12 PM, Andreas Wenk wrote:
> Ms swati chande schrieb:
>
>> --- On *Wed, 7/8/09, Andreas Wenk //*
>> wrote:
>>
>>
>>From: Andreas Wenk
>>Subject: Re: [GENERAL] Password?
>>To: "Ms swati chande" , "PG-General Mailing List"
>>
>>Date: Wednesday, July 8,
On Mon, Aug 3, 2009 at 11:11 AM, wrote:
>
>
>
>
> >
> > It seems you are trying to drop a replication cluster, to drop a
> > this you have to do as follows:
> >
>
> Yes it is a replication cluster. I am using Slony to replicate
> my 8.1.11 database on CentOS 5.
>
>
> > connect
PGDATA=some/path/pgtest .
To start the postgresql server using pg_ctl you can use,
pg_ctl -D PGDATA start
to stop ,
pg_ctl -D PGDATA stop
Abbas.
> Any hints how to use pg_ctl to start/stop postgresql on a unix domain
> socket?
>
> --
> Sent via pgsql-general mailing list
gres/centos@
[3947] 1385322573.418896: Read AP-REP, time 1385322576.407247, subkey
aes256-cts/710D, seqnum 574336718
Please suggest my where am missing.
Thanks in advance.
Abbas
Best Regards,
Abbas
On Mon, Aug 15, 2011 at 11:14 PM, tamanna madaan <
tamanna.mad...@globallogic.com> wrote:
> Hi All
>
> I am using postgres-8.4.0 on a cluster setup with slony-2.0.4 being used
> for replication.
> Recently , I saw a "idle in transaction&
_dump or
> pg_restore?
>
> Or is there any query to enable all the dissabled triggers in a database
> schema?
>
> Please let me know I will be highly obliged.
>
>
>
> Are you sure that you didn't use --disable-triggers option while taking
the pg_dump?
---
Abbas.
> --
> Thanks & Regards
> Gaurav K Srivastav
>
Best Regards,
Abbas
On Wed, Apr 25, 2012 at 11:16 AM, Akhila Banu Rumi <
akhilabanu_r...@infosys.com> wrote:
> Really Heart touching …
>
> ** **
>
> *From:* Amey Ratnakar Prabhu
> *Posted At:* Wednesday, April 25, 2012 9:16 AM
> *Posted To:* HYD General
>
l-core 2,0Ghz, 2GB RAM, SATA
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Is the table has indexes?
Decreasing the work_mem also increase performance.
Monitor these changes by explain the query plan.
Regards,
Abbas.
Thx for help.
Noah
Are you trying to do this from a plpgsql function? If so then I think
you should try to do this from a C function.
With C functions you will get more control over the new and old
versions of the tuple since you get their pointers via
TriggerData->tg_trigtuple (old tuple)
ROTECTED] ~]$ psql --version
psql (PostgreSQL) 7.4.8
contains support for command-line editing
thx.
This can happen when your index is/are corrupted. Try issuing a
reindex command.
regards,
--
Sibte Abbas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
_server_log() function in elog.c?
thanks,
--
Sibte Abbas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
exec gdb $PGINSTROOT/bin/postgres -silent
fi
This will attach directly to the target backend if there's only one,
else you can examine the ps output to determine which PID to attach to.
regards, tom lane
Also, for gdb to function properly, you should compile the s
On 7/22/07, Sibte Abbas <[EMAIL PROTECTED]> wrote:
On 7/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Shreya Bhargava <[EMAIL PROTECTED]> writes:
> > 1. gdb postgres
> > 2. set args -D test (test is my dbcluster)
> > 3. b hashbuild(this is the function i
tters/2007-07/msg00215.php
Makes sense.
regards,
--
Sibte Abbas
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 8/2/07, Sergey Moroz <[EMAIL PROTECTED]> wrote:
> The problem is that I can't find the way to exclude query parsing (prepare
> step) for custom queries. In other words I want to create a function that
> accepts a query text with "$1, $2, etc." and variables as params, executes
> the query and re
On 8/3/07, Sergey Moroz <[EMAIL PROTECTED]> wrote:
> No that is not I meant. The problem in Prepared statements is in that you
> should determine SQL inside the function. I want to pass a query as a
> parameter, as well as query parameters.
> For example (I want to create a function like the follow
On 8/25/07, Thobiyas <[EMAIL PROTECTED]> wrote:
> Dear sir
> how can get the log file in postgres sql
>
> --
> **
> P.Maria Antony Thobiyas
> Bosco InfoTech Pvt Ltd
>
> Mobile: 09486144070 (Personal)
> ***
-- Forwarded message --
From: Sibte Abbas <[EMAIL PROTECTED]>
Date: Aug 31, 2007 8:32 AM
Subject: Re: [GENERAL] Query the catalog
To: Ottó Havasvölgyi <[EMAIL PROTECTED]>
On 8/31/07, Ottó Havasvölgyi <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> How can I q
-
> TIP 2: Don't 'kill -9' the postmaster
>
AFAIK the FOUND variable does not get updated as part of an EXECUTE command.
Consider using a strict INTO clause alongwith EXECUTE. This way a
NO_DATA_FOUND exception will be generated if your query did'nt return any
data. Something like this:
DECLARE
v_rec record;
BEGIN
EXECUTE ''SELECT * FROM '' || TG_RELNAME || '' WHERE fldclientnumber = '' ||
NEW.fldclientnumber INTO STRICT v_rec;
EXCEPTION
when no_data_found then
/* do something */
regards,
--
Sibte Abbas
c
> case where i need it. Can it be done?
>
AFAIK Locking the entire database may not be an option in postgresql.
However you can virtually restrict access to everyone to a particular
database via pg_hba.conf.
More details here
http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf
Hello all
Can we check whether a cursor is OPEN or not in plpgsql.
Like in oracle you can check a CURSOR'S state with %ISOPEN
After navigating the documentation i was not able to find an
equivalent in plpgsql.
Do we have an alternative to this in plpgsql?
Thankz
---(end
thankz :-)
On 4/10/05, Bruce Momjian wrote:
> Sibtay Abbas wrote:
> > Hello all
> >
> > Can we check whether a cursor is OPEN or not in plpgsql.
> > Like in oracle you can check a CURSOR'S state with %ISOPEN
> >
> No, but we do have a TODO item:
>
hello everyone
i am having problem with multidimensional arrays in plpgsql following
is the source code of the function which i am trying to run
CREATE OR REPLACE FUNCTION test() RETURNS VOID AS $$
DECLARE
x INTEGER[10][10];
tmp VARCHAR(40);
BEGIN
x[3][1] := '20'; --i have even
On Wed, 26 Jan 2005 12:40:24 +0500, Sibtay Abbas <[EMAIL PROTECTED]> wrote:
> hello everyone
>
> i am having problem with multidimensional arrays in plpgsql following
> is the source code of the function which i am trying to run
>
> CREATE OR REPLACE FUNCTION test() RETU
Add "NOT NULL" keyword in the WHERE clause of your SUB SELECT statement
something like that
..NOT IN ( SELECT contact_id FROM
tb_contact_role WHERE type2 <> 72 AND type2 NOT NULL)
On Wed, 26 Jan 2005 15:03:17 +, mike <[EMAIL PROTECTED]> wrote:
> I have the following query
>
> SE
hi all
How are function parameters generally passed in postgresql.
More specifically when we pass a variable to a plpgsql function is
passed by value or by reference
Thank You
---(end of broadcast)---
TIP 2: you can get off all lists at once with t
Hi, Mr. PG..
what is PG version operating OLAP operations ?
Thanks..
--Hira Sirojudin--
--Jurusan Teknik Komputer dan Informatika - Politeknik Negeri Bandung
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
29 matches
Mail list logo
