-I/usr/include/postgresql/9.1/server ...
>
> I want to build for 9.2. How can I do this?
>
> Before compiling point pg_config to PG 9.2
export PATH=/your/path/to/pg92/bin:$PATH
And check whether its pointing to PG 9.2 by below command.
which pg_config
Re-configure plr.
---
Regards,
Ragh
lines )
3. Also PostgreSQL version.
Slony-I mailing list address:
slony1-gene...@lists.slony.info
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
you try CHECKPOINT before pg_stop_backup() and see whether it meets
your requirement ?
http://www.postgresql.org/docs/8.0/static/sql-checkpoint.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
se other sources like pg_extractor tools.
http://www.keithf4.com/pg_extractor/
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
>
>
> Thanks,
>
> Keith
>
>
>
as a more elegant method for obtaining this
> information? I've googled a bit, and haven't found any SQL magic to
> do it, but perhaps I'm just not searching for the right thing?
>
> thanks
>
> You can check with pg_stat_replication for replicating server's
informat
query plan in logs i.e.,
AUTO_EXPLAIN.
http://www.postgresql.org/docs/9.2/static/auto-explain.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
read from any different location then set environment
variable PSQLRC.
http://www.postgresql.org/docs/9.2/static/app-psql.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
You can use trail version of PEM, a product of EnterpriseDB. Am not a
sales guy :), just came out as you said the word "Like OEM for oracle".
http://www.enterprisedb.com/products-services-training/products/postgres-enterprise-manager
---
Regards,
Raghavendra
EnterpriseDB Corporation
he pg_catalogs.
Presently, in mind I can only think reindexing the system catalog would be
right option "reinidexdb -s".
Other's might have good options in fixing this, you should wait for another
suggestion.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Jul 3, 2012 at 12:48 PM, Samuel Stearns
wrote:
> Before and after analyze:
>
> ** **
>
> select schemaname,relid,indexrelid,relname,indexrelname from
>
> pg_stat_all_indexes where relname='input_transaction_snbs';
>
> ** **
>
> schemaname | relid | indexrelid |reln
On Tue, Jul 3, 2012 at 10:19 AM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
>
> On Tue, Jul 3, 2012 at 9:25 AM, Samuel Stearns
> wrote:
>
>> Results of \d (without all the column defs):
>>
>> Indexes:
>> "input_transaction_snbs_prod_
On Tue, Jul 3, 2012 at 9:25 AM, Samuel Stearns wrote:
> Results of \d (without all the column defs):
>
> Indexes:
> "input_transaction_snbs_prod_pkey" PRIMARY KEY, btree (id)
> "i1" btree (trans_client)
> Check constraints:
> "chk_charge" CHECK (charge_type IS NULL OR charge_type =
> '
>
>
> which is creating a 2nd duplicate index in error as this query shows:
>
> **
>
Hmm,,, that's strange.. Can you update with the output of the below command.
\d input_transaction_snbs
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
ted in logs copy it to $PGDATA/pg_xlog location and start the
server. Sometime, server will throw the sequence of files like 41,42,
not existing, you need to copy all of them to pg_xlog location and start it.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
O
more information without shipping the
> user a new build? The Postgres log, at least at notice level, doesn't
> appear to show anything more useful than the error message.
>
>
Bug ? Am not sure... You need to wait for other respected community member
suggestions and proceed accordingly.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
too? If not, the
> difference could be due to index space I guess.
>
> Thanks!
>
> Yes, pg_database_size include indexes in the database.
Can you also tell what replication is in place ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> --
&
ut you need see "Database cluster state: " is "in recovery mode"
and "Time of latest checkpoint:", "Minimum recovery ending location:"
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> I have gone through the docume
Yep, it cannot be changed at session-level.
http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Fri, Mar 16, 2012 at 5:24 PM, Marc Mamin wrote:
> **
>
> Hello,
>
>
ng to write
information about connections. See log_connections & log_disconnections
http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
>
> --
> Sent via pgsql-admin mailing list
EXCLUSIVE MODE *Works as a Select *For update* clause.
*
*
http://www.postgresql.org/docs/9.0/static/sql-lock.html
I believe you should give a try test on this.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
access on slave box then I
believe you need to choose any Trigger Based Replication.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
There is very good documentation in main.slony.info.
If you like to implement a basic replication setup, you can try out this.
http://abbasameen.blogspot.com/2010/06/slony-with-postgres.html
-- Raghav
On Thu, Sep 22, 2011 at 1:37 PM, Karuna Karpe
wrote:
> Hello,
>
> please let me kno
-over when the primary server is NO longer available (ie in a
Disaster).
slonik_failover -c slon.conf 1 2
slonik_failover -c slon.conf 1 2 | ./slonik
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Mon, Sep 19, 2011 at 12:16 PM, Karuna Karpe wrote:
&g
and do changes as per your requirement.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Sun, Sep 18, 2011 at 2:55 PM, Melaka Gunasekara wrote:
> Hi all,
>
> I came across
> http://www.postgresql.org/docs/8.4/static/runtime-config-quer
>
> For example:
CREATE TABLE tb(name varchar(32));
You can get this with System functions.
select pg_column_size(name) from tb;
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Sep 7, 2011 at 8:50 PM, shuaixf wrote:
>
> According
I think you should also need 'zlib-devel', check with the rpm's list of zlib
in your OS.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Aug 18, 2011 at 5:06 PM, Venkat Balaji wrote:
> Hello Community,
>
> I am getting
ink it is possible if you are missing any one of the WALs in
restoration process.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Ahh,,, I missed this.. :)
Thank you Tom for pointing to appropriate direction. Below command worked
/usr/ucb/ps -ww
--Raghav
On Tue, Aug 9, 2011 at 9:15 PM, Tom Lane wrote:
> Raghavendra writes:
> > Still, my guess we cannot get the process description on SunOS.
>
> I sur
Nope.
SR supports with the same file-system architecture between Master and Slave.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Aug 4, 2011 at 7:38 PM, pawcyk wrote:
> Hi,
>
> I'm trying set up streaming replication between
I go with Kevin.
Still, my guess we cannot get the process description on SunOS.
--Raghav
On Tue, Aug 9, 2011 at 8:18 PM, Kevin Grittner
wrote:
> iliya g wrote:
>
> > The problem is that when I run ps - ef l grep postgres, I only get
> > postgres and not the process description.
>
> It's hard t
Only active 'postgres' process you can see with description, rest will be in
'IDLE'.
Moreover, which operating system you are in..
--Raghav
On Tue, Aug 9, 2011 at 7:54 PM, iliya g wrote:
> Thanks, Raghavendra.
>
> The problem is that when I run ps - ef l grep
es: postgres postgres
[local] SELECT
In the above example, you can see both mandatory process and user-process
performing 'SELECT' operation.
To identify postgres process uniquely, you can get it from catalog view
'pg_stat_activity'.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> Thanks.
>
In PostgreSQL, instance cannot recognize the network failure, however, I
think you can do with OS scripting and calling in "archive_command".
Eg:-
archive command = '/home/scripts/arch_copy.sh %p %f'
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blo
Here is the setting information on pg_service.conf
http://www.postgresql.org/docs/9.0/interactive/libpq-pgservice.html
---
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Fri, May 20, 2011 at 6:01 PM, Teguh R wrote:
> Hi,
>
> My first pos
gt; the
> > cluster.
> > In Oracle, we can flush the SGA, can we get the same feature here..
> > Thanks in Advance.
>
>
> The CHECKPOINT command will do this for you.
>
This command will empty the PSM...
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
ere proname = 'your_function'
>
>
>
Small correction..
select pg_get_functiondef(oid) from pg_proc where proname = 'your_function'
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.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
>
select oid,proname from pg_proc where proname='function-name';
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Mon, May 2, 2011 at 10:22 PM, wrote:
> I've just started working on an 8.4 database and I have been asked to
> extr
Hi Mark,
Similar posting on partition table, take this inputs before going forward
with partition table.
http://archives.postgresql.org/pgsql-general/2011-04/msg00808.php
Best solution given by Greg Smith as well Vick.
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres
38 matches
Mail list logo
