Hi All;
A client's master database crashed, they tried to startup the streaming
replication slave and it refuses to start.
See the log details below... thanks in advance for any help
Master log:
2013-07-30 16:23:01 MDT PANIC: corrupted page pointers: lower = 0, upper
= 0, special = 0
On 7/17/13 10:40 AM, Nestor A. Diaz wrote:
Hello Nestor
I use its:
standby_mode = 'on'
primary_conninfo = 'host=X.X.X.X port=5432 user= password=YTT'
trigger_file = '/var/pgsql/data/pg_failover_trigger'
restore_command = 'cp /wal/%f /var/lib/postgresql/8.4/main/%p'
Ok, but those
All;
We're doing a migration as follows:
1) we setup a HOT standby pair
2) we did an import of a db that wan backed up via pg_dump
The pg_xlog directory has 1700 files in it, It seems that the slave is
way behind which I get since we just imported a 55GB database but the
slave is not
All;
We have a client that is asking for a service as follows:
- a virtual machine in our data center
- they want to upload files to the VM via sftp
- they want to connect to a local db server on the VM via SSL
Here's my question;
Do I need to pay for an official SSL cert? If so, they seem to
On 1/5/13 1:54 PM, J Rouse wrote:
Stupid person here. Just got PostgresSQL today. Have text dump
file. Need to restore.
I think I need to use psql, but do not even know how to get to it.
Need exact instructions on where to enter the command line, setting up
paths if necessary, etc.
Jim
Hi all;
I'm building 9.2.2 from source on a Scientific Linux 6.2 box.
I downloaded the tar.bz2 file from here:
http://www.postgresql.org/ftp/source/v9.2.2/
I unzipped the file and ran this:
./configure --prefix=/usr/local/pgsql --with-perl --with-openssl
then I get this error:
checking for
On 1/5/13 10:58 AM, CS DBA wrote:
Hi all;
I'm building 9.2.2 from source on a Scientific Linux 6.2 box.
I downloaded the tar.bz2 file from here:
http://www.postgresql.org/ftp/source/v9.2.2/
I unzipped the file and ran this:
./configure --prefix=/usr/local/pgsql --with-perl --with-openssl
Hi all;
where does the system psqlrc file live?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi all;
I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac).
I disables selinux on both, and installed postgres 8.4.13 on both VM's
I set listen_addresses = '*'
and I added a trust entry for each server in the opposite server's pg_hba.conf
file.
However I cannot access one server
Hi All;
I just installed Fedora 16, I was running fedora 14.
I installed Postgresql from source and set SHMMAX to 2198066816
I set postgres to use 2GB for shared_buffers and I get this when I try
to start:
FATAL: shmat(id=4096103) failed: Cannot allocate memory
The only real difference
On 11/30/2011 05:05 PM, M. D. wrote:
On 11/29/2011 11:52 PM, senthilnathan wrote:
Is there any simple way to define read only roles. Basically that
user should
be able to login and be able to do *select* statements alone. It
should be
applied for all tables in all schemas in a database.
--
On 08/11/2011 08:09 PM, Craig Ringer wrote:
On 11/08/2011 10:57 PM, CS DBA wrote:
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced
Hi All;
I have a client that wants the following:
- 2 masters (master to master replication)
- multiple read only slaves off each master
- the ability to failover in case of a master node failure
to include re-directing the slaves off the failed master to now
point to the remaining
Hi All;
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
Thanks in advance...
--
-
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bundled.
Regards,
That was the first
Hi All;
we're trying to get PostgreSQL configured on an AIX box (AIX version 5).
After some digging adding various paths to LD_LIBRARY_PATH (Thanks to
help from Tom Lane) we were able to complete the source based build.
However, when we try and start the db we get the following:
$ pg_ctl
Hi All;
We're getting the following error when we try to run initdb on an AIX box:
fgets failure: Error 0
The program postgres is needed by initdb but was not found in the same
directory as /opt/app/postgres/904/bin/initdb.
Check your installation.
We did this:
1) installed (via source)
On 08/10/2011 01:16 PM, Tom Lane wrote:
CS DBAcs_...@consistentstate.com writes:
We're getting the following error when we try to run initdb on an AIX box:
fgets failure: Error 0
The program postgres is needed by initdb but was not found in the same
directory as
On 08/10/2011 02:22 PM, Tom Lane wrote:
CS DBAcs_...@consistentstate.com writes:
On 08/10/2011 01:16 PM, Tom Lane wrote:
This means that initdb tried to execute postgres -V and didn't get any
output. What happens when you try that directly?
See below. One oddity, if I compile without the
nevermind, domain type
I'm seeing a number of serial_fkey data types in one of our databases
(postgresql 8.4) but I dont find this data type in the docs. Where
does this come from?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
I'm seeing a number of serial_fkey data types in one of our databases
(postgresql 8.4) but I dont find this data type in the docs. Where does
this come from?
Thanks in advance
--
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
Hi All;
I have several prepared tx which are running for a long long time. I
want to kill 'em but I dont know the process id. I can get the xid via
pg_prepared_xacts.transaction however the tx's have no locks thus no
corresponding pg_locks row. Anyone know how I can get a procpid based
on a
On 02/17/2011 07:19 PM, Tom Lane wrote:
CS DBAcs_...@consistentstate.com writes:
I have several prepared tx which are running for a long long time. I
want to kill 'em but I dont know the process id.
If they're prepared, they're *not* running, and they don't have a
process id. They're just
On 02/17/2011 07:48 PM, CS DBA wrote:
On 02/17/2011 07:19 PM, Tom Lane wrote:
CS DBAcs_...@consistentstate.com writes:
I have several prepared tx which are running for a long long time. I
want to kill 'em but I dont know the process id.
If they're prepared, they're *not* running
On 02/09/2011 03:49 PM, Jim Mlodgenski wrote:
On Wed, Feb 9, 2011 at 2:59 PM, Bryan Kellerbrya...@gmail.com wrote:
I am considering running a Postgres with the database hosted on a NAS via NFS.
I have read a few things on the Web saying this is not recommended, as it will
be slow and could
One of the main considerations per Hot Standby vs SLONY is replication
scope. With Hot Standby you get everything that occurs in the cluster,
across all databases. With SLONY you are limited to at most a single
database per SLONY Cluster, and you can define replication sets which
only contain
Hi All;
I suspect I know the answer to this...
What's the current state of multi-master replication for PostgreSQL? Is
Bucardo the only true master/master solution out there that might be
worthy of a production push? Is Postres-R a candidate at this point (I
suspect not)? Are there any
27 matches
Mail list logo