Hi Team,
For last 2 days we are facing issue with replication.
WARNING: page 21 of relation base/1193555/19384612 does not exist
CONTEXT: xlog redo insert: rel 1663/1193555/19384612; tid 21/1
PANIC: WAL contains references to invalid pages
CONTEXT: xlog redo insert: rel 1663/1193555/19384612;
Kevin Grittner wrote:
> > Vishalakshi Navaneethakrishnan wrote:
> >
> >> select * from pg_database where datname = 'template0';
> >> -[ RECORD 1 ]-+
> >> datname | template0
> >> datdba| 10
>
Hi All,
select * from pg_database where datname = 'template0';
-[ RECORD 1 ]-+
datname | template0
datdba| 10
encoding | 6
datcollate| en_US.UTF-8
datctype | en_US.UTF-8
datistemplate | t
datallowconn | f
datconnlimit | -1
datlastsy
/redhat_transparent_hugepage/defrag
[always] never
On Thu, Aug 8, 2013 at 10:57 AM, Sergey Konoplev wrote:
> On Wed, Aug 7, 2013 at 9:32 PM, Vishalakshi Navaneethakrishnan
> wrote:
> > cat /etc/issue
> > CentOS release 6.3 (Final)
> >
> > cat /proc/meminfo |grep Hugepagesize
&
eze analyze everyday.
We are using Centos
cat /etc/issue
CentOS release 6.3 (Final)
cat /proc/meminfo |grep Hugepagesize
Hugepagesize: 2048 kB
On Thu, Aug 8, 2013 at 6:59 AM, Sergey Konoplev wrote:
> On Wed, Aug 7, 2013 at 2:46 AM, Vishalakshi Navaneethakrishnan
> wrote:
> > Da
Hi All,
We have one production database server , having 6 DBs, Postgres 9.2.1
version.
This is my vacuum settings in Production database
#autovacuum = on# Enable autovacuum subprocess?
'on'
# requires track_counts to also be
on.
lo
Hi all,
Can we create composite index for one text column and integer column?
Thanks in advance..
--
Best Regards,
Vishalakshi.N
Hi all,
Can you please tell me , how to set up replication in win7, without slony
tool..
--
Best Regards,
Vishalakshi.N
PM, Vishalakshi Navaneethakrishnan
> wrote:
> > Hi all,
> >
> > I need to know who are all access database from different remote host.
> >
> > Example :
> >
> > User1@host1 logged / access db dbuser@dbname in Dbserver
> >
> > How can i get this inform
Hi all,
I need to know who are all access database from different remote host.
Example :
User1@host1 logged / access db dbuser@dbname in Dbserver
How can i get this information?
Thanks in advance..
--
Best Regards,
Vishalakshi.N
i found pg_upgrade binary missing in bin directoy. How
can i get this ?
Thanks in Advance.
On Sat, Oct 13, 2012 at 3:37 AM, Scott Marlowe wrote:
> On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan
> wrote:
> > Hi Friends,
> >
> > We have our production env
Hi Friends,
We have our production environment database server in Postgres 8.3 version.
we have planned to upgrade to lastest version 9.1. Dump from 8.3 and
restore in Postgres 9.1 takes more than 5 hours. Any other quick method to
upgrade from 8.3 to 9.1. We need to reduce our downtime below 1
12 matches
Mail list logo