> Now you can edit the dump and attempt to restore it until it succeeds
> on a different system, after which you know for certain that your data
> matches at least your integrity constraints.
>
> That makes sense to me, thanks Is there is an easier or better way
> to edit the binary dump file?
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Thursday, June 19, 2014 3:34 PM
To: Khangelani Gama; Alban Hertroys
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of file ,
ERROR: missing data for column
-Original Message-
From: Alban Hertroys [mailto:haram...@gmail.com]
Sent: Thursday, June 19, 2014 1:54 PM
To: Khangelani Gama
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of file ,
ERROR: missing data for column
On 19 June 2014 13:11
> Adrian you might be right I have just tried to pg_restore on the same
> server(8.4.2), I get the same errors related to xml. Can someone
> advise if the following XML file as an example is in the correct state or
> not:
Hi all
I have a question, why is that pg_dump does not fail when dumping t
> Adrian you might be right I have just tried to pg_restore on the same
> server(8.4.2), I get the same errors related to xml. Can someone
> advise if the following XML file as an example is in the correct state or
> not:
The other strange thing is:
ERROR: missing data for column "fpp_cde"
CONTEX
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Wednesday, June 18, 2014 1:06 PM
To: 'Adrian Klaver'; 'Andres Freund'; 'Tom Lane'
Cc: 'Alban Hertroys'; 'Ziggy Skalski'; 'pgsql-general@postgresql.org'
S
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, June 18, 2014 4:32 AM
To: Khangelani Gama; Andres Freund; Tom Lane
Cc: Alban Hertroys; Ziggy Skalski; pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of
-Original Message-
From: Andres Freund [mailto:and...@2ndquadrant.com]
Sent: Tuesday, June 17, 2014 4:38 PM
To: Tom Lane
Cc: Alban Hertroys; Khangelani Gama; Ziggy Skalski;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of file
, ERROR
column
On 2014-06-17, 8:08 AM, Khangelani Gama wrote:
I keep getting the following error when trying to restore a database on
Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s working
fine for other similar databases.
Hi there,
Did you do the pg_dump using 9.2
I keep getting the following error when trying to restore a database on
Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s working
fine for other similar databases.
Hi there,
Did you do the pg_dump using 9.2 binaries or the 8.4 binaries? It's
recommended that yo
column
On 2014-06-17, 5:33 AM, Khangelani Gama wrote:
Hi
I keep getting the following error when trying to restore a database on
Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s working
fine for other similar databases.
And then restoring the database on
Hi
I keep getting the following error when trying to restore a database on
Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s working
fine for other similar databases.
And then restoring the database on another server running on 9.2.4 using
pg_restore –Fc. I ge
-Original Message-
From: Kevin Grittner [mailto:kgri...@ymail.com]
Sent: Saturday, June 14, 2014 8:16 PM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Using pg_start_backup() and pg_stop_backup() -
using 9.1.2.2
Khangelani Gama wrote:
> I am doing
Hi all
Please help me here.
I am doing the following between master and the backup server using
archive_command,
I am using O/S - Red Hat Enterprise Linux Server release 5.3 (Tikanga)
On backup or secondary server I did the following:
1. Stopped postgres in backup server
> Was the database server restarted after the new version was built?
> It was not restarted - Should I do so?
Yes, otherwise the old binary will still be running.
Do also take note of Craig Ringer's email on this thread; in particular you
should always run the latest minor version, which is curr
-Original Message-
From: Ian Barwick [mailto:i...@2ndquadrant.com]
Sent: Thursday, June 12, 2014 11:05 AM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL
using --with-libxml
On 14/06/12 17:23, Khangelani Gama wrote:
> Hi
, Khangelani Gama wrote:
I then did the following:
1. We installed library 'xml2' (version >= 2.6.23)
2. ./configure --with-libxml
3. gmake
4. gmake install
was the previous version custom built with /no/ options ?
-I am not sure because it’s setup I was not involved
Hi all
I was asked by application dev to rebuild PostgreSQL with libxml because
they get the following error from the server.
WITH x(col) AS (SELECT 'ERROR_MISSING_DATA'::xml)
SELECT xpath('./status/text()', col) AS status
FROM x;
LINE 1: WITH x(col) AS (SELECT '= 2.6.23)
2. ./config
Thank You, I will have a look.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, June 10, 2014 3:45 PM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_standby replication problem
On 06/09/2014 10:02 PM, Khangelani Gama
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, June 10, 2014 1:42 AM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_standby replication problem
On 06/09/2014 11:15 AM, Khangelani Gama wrote:
> This is the stan
This is the standby replication setting with archive_command sending the
WALs from master to standby.
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Monday, June 09, 2014 8:06 PM
To: pgsql-general@postgresql.org
Subject: pg_standby replication problem
Hi All
Hi All
I would like to re-post the problem we have. The secondary server ran out
the disc space due the replication problem (Connection Time out).Since there
was a Connection time out Problem in the primary server, how can I make disc
space in the secondary server for the replication to continue f
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Monday, June 09, 2014 5:26 PM
To: 'Alan Hodgson'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] pg_standby replication problem
I just saw got this from the primary server (/tmp/ru
I just saw got this from the primary server (/tmp/run_replication.sh.out),
secondary server's IP 10.58.101.10.
replication started: Sun Jun 8 00:05:26 SAST 2014 source:
pg_xlog/00054BAF00AF, dest: 00054BAF00AF
replication finished: Sun Jun 8 00:05:33 SAST 2014
replicati
Khangelani Gama wrote:
> Please help me with this, my secondary server shows a replication problem.
> It stopped at the file called *00054BAF00AF …*then from
> here primary server kept on sending walfiles, until the walfiles used
> up the disc space in the data directory.
Please please help
*From:* Khangelani Gama [mailto:kg...@argility.com]
*Sent:* Monday, June 09, 2014 1:42 PM
*To:* pgsql-general@postgresql.org
*Subject:* pg_standby replication problem
Please help me with this, my secondary server shows a replication problem.
It stopped at the file called
6M Jun 7 21:42 00054BAE000000F7
*From:* Khangelani Gama [mailto:kg...@argility.com]
*Sent:* Monday, June 09, 2014 1:45 PM
*To:* pgsql-general@postgresql.org
*Subject:* RE: pg_standby replication problem
FilesystemSize Used Avail Use% Mounted on
/dev/sda3
space Breakdown:*
4.0K./backup
12K ./copy
4.9T./data
204K./test
16K ./lost+found
361G./walfiles
5.3T.
*From:* Khangelani Gama [mailto:kg...@argility.com]
*Sent:* Monday, June 09, 2014 1:42 PM
*To:* pgsql-general@postgresql.org
*Subject:* pg_standby
Please help me with this, my secondary server shows a replication problem.
It stopped at the file called *00054BAF00AF** …*then from here
primary server kept on sending walfiles, until the walfiles used up the
disc space in the data directory. How do I fix this problem. It’s postgres
9.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, May 26, 2014 5:35 PM
To: Alban Hertroys
Cc: Khangelani Gama; Thomas Kellerer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgreSQL : duplicate DB names
Alban Hertroys writes:
> On 26 May 2014, at 10
-Original Message-
From: Alban Hertroys [mailto:haram...@gmail.com]
Sent: Monday, May 26, 2014 11:11 AM
To: Khangelani Gama
Cc: Thomas Kellerer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgreSQL : duplicate DB names
On 26 May 2014, at 10:28, Khangelani Gama wrote:
> On
-Original Message-
From: Alban Hertroys [mailto:haram...@gmail.com]
Sent: Monday, May 26, 2014 10:21 AM
To: Khangelani Gama
Cc: Thomas Kellerer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgreSQL : duplicate DB names
On 26 May 2014, at 10:09, Khangelani Gama wrote
, May 26, 2014 9:42 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgreSQL : duplicate DB names
Khangelani Gama, 26.05.2014 09:20:
> Hi
>
> Something wrong happened in our server, for some strange and unknown
> reason (s) the server created another DB, there is two same DB names
Hi
Something wrong happened in our server, for some strange and unknown reason
(s) the server created another DB, there is two same DB names in one
server. How I can I fix this. Please help
Name| Owner | Encoding
+--+--
a9004| postgres | UNICODE
Thank you very much to everyone, it worked
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Thursday, May 22, 2014 3:01 PM
To: 'Igor Neyman'; 'Andrew Sullivan'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Need help on t
Many Thanks, I will try it now
-Original Message-
From: Igor Neyman [mailto:iney...@perceptron.com]
Sent: Thursday, May 22, 2014 2:55 PM
To: Khangelani Gama; Andrew Sullivan; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Need help on triggers - postgres 9.1.2
> > -Or
Thanks , I will try that
-Original Message-
From: Raymond O'Donnell [mailto:r...@iol.ie]
Sent: Thursday, May 22, 2014 2:54 PM
To: Khangelani Gama; Andrew Sullivan; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need help on triggers - postgres 9.1.2
On 22/05/2014 13:48, Khang
ts. Center table has got many rows so I need
to only get c_cde for only the row that was inserted.
-Original Message-
From: Andrew Sullivan [mailto:a...@crankycanuck.ca]
Sent: Thursday, May 22, 2014 2:39 PM
To: Khangelani Gama
Subject: Re: [GENERAL] Need help on triggers - postgres 9.1.2
Please help
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Thursday, May 22, 2014 9:38 AM
To: 'Adrian Klaver'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Need help on triggers - postgres 9.1.2
Hi all
Something it's t
check_center_changes();
-----Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Wednesday, May 21, 2014 9:34 PM
To: 'Adrian Klaver'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Need help on triggers - postgres 9.1.2
Thank you very m
Thank you very much, I will have a look.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, May 21, 2014 3:20 PM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need help on triggers - postgres 9.1.2
On 05/21/2014 02:54 AM
Hi
I have a postgres 9 database, inside this database I need to create a new
table called *center_changed* that gets inserted by any change that take
place in a table called *center*. So I need to create trigger to do this.
*Example: *
Table name*: center*(c_cde, c_dsc, ops_cde, grp_cde);
Sorry
I found the problem, it’s data problem in another database, it’s trying to
convert numeric null but of which it’s not a null data, it’s a blank data.
*From:* Khangelani Gama [mailto:kg...@argility.com]
*Sent:* Tuesday, May 20, 2014 12:24 PM
*To:* pgsql-general@postgresql.org
*Subject
Hi
The follow query below works in one database but not on another database.
The databases are similar but independent of each other. From the previous
post I found that: *This is fixed by casting the first argument to **text*
*:,* but I can’t see which COALESCE to fix out the several COALESCE
from
(select distinct(cus_acno), contact.con_id, address.addr_id from address
join person using (addr_id) join cus using (per_id) join link_contact
using (cus_acno) join contact using (con_id) where contact.addr_id is null)
b
where contacts.con_id=b.con_id
On 05/15/2014 09:19 AM, Khangelani Gama
Hi
Please help, we are using postgreSQL 9.2.4. I need to update over 9000
rows. See the query below: A table called contact has got *addr_id *field
as null which is incorrect. So now I need to update contact table for each
account (cus_acno is in cus table) where contact_addr_id is null. For
ex
;
update foo
set br_desc = bar.br_desc
, br_active = bar.br_active
(rest of columns)
where foo.br_cde = bar.br_cde;
databases has got:
SHOW search_path;
search_path
"$user",public
(1 row)
*From:* Khangelani Gama [mailto:kg...@argility.com]
*Sent
;
update foo
set br_desc = bar.br_desc
, br_active = bar.br_active
(rest of columns)
where foo.br_cde = bar.br_cde;
databases has got:
SHOW search_path;
search_path
"$user",public
(1 row)
*From:* Khangelani Gama [mailto:kg...@argility.com ]
*Sent
Thank you very much, I on my previous try I did not include the FROM. I
will just do thoroughly checks before COMMIT. Thanks very much.
*From:* ccur...@gmail.com [mailto:ccur...@gmail.com] *On Behalf Of *Chris
Curvey
*Sent:* Friday, March 28, 2014 2:38 PM
*To:* Khangelani Gama
*Cc:* pgsql
:* Khangelani Gama
*Cc:* pgsql
*Subject:* Re: [GENERAL] Synchronizing a table that is in two different
databases : Need to dump a table as inserts from db1 and change the insert
statements into UPDATE statements
On Fri, Mar 28, 2014 at 5:56 AM, Khangelani Gama wrote:
Hi Chris or anyone who can
;
update foo
set br_desc = bar.br_desc
, br_active = bar.br_active
(rest of columns)
where foo.br_cde = bar.br_cde;
*From:* Khangelani Gama [mailto:kg...@argility.com ]
*Sent:* Friday, March 28, 2014 7:52 AM
*To:* 'ch...@chriscurvey.com'; 'pgsql'
*Su
's in
db1.
*From:* ccur...@gmail.com [mailto:ccur...@gmail.com] *On Behalf Of *Chris
Curvey
*Sent:* Thursday, March 27, 2014 3:08 PM
*To:* Khangelani Gama; pgsql
*Subject:* Re: [GENERAL] Synchronizing a table that is two different
databases : Need to dump a table a insert from db1 and change
:* Rémi Cura [mailto:remi.c...@gmail.com]
*Sent:* Thursday, March 27, 2014 1:54 PM
*To:* Khangelani Gama
*Cc:* PostgreSQL General
*Subject:* Re: [GENERAL] Synchronizing a table that is two different
databases : Need to dump a table a insert from db1 and change the insert
statements into UPDATE
Hi all
Synchronizing a *table* that is in two different databases(e.g *db1 and db2*).
Please help me with this. I need to dump a table as INSERTS from db1
(postgres 9.1.2) and change the INSERT statements into UPDATE statements in
order to apply that change in *db2(postgres 8.3.0.112)* which
@postgresql.org
Subject: Re: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate
memory
On 4/23/2013 11:08 PM, Khangelani Gama wrote:
> Hi John
>
> Yes that's the whole messege
>
well, try something like...
kernel.shmmax = 4294967295
kernel.shmall = 268435456
a
:8184 kB
DirectMap2M: 905216 kB
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Wednesday, April 24, 2013 8:09 AM
To: 'John R Pierce'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot
/2013 10:53 PM, Khangelani Gama wrote:
> We are running postgres 9.1 on CentOS 5. We can't start up postgres .
> It complains about memory allocation . Please help
>
> FATAL: shmat(id=3342337) failed: Cannot allocate memory
>
is that the entire error message? it usually say
Hi all
We are running postgres 9.1 on CentOS 5. We can’t start up postgres . It
complains about memory allocation . Please help
FATAL: shmat(id=3342337) failed: Cannot allocate memory
# - Memory -
shared_buffers = 310251
# (change requires r
Thanks at lot.
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Thursday, August 30, 2012 1:22 PM
To: Khangelani Gama *EXTERN*; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Need help on autovacuum in postgres 9.1.2
Khangelani Gama wrote:
> I need h
Hi
I need help in turning off autovacuum in the Database that’s running
postgres 9.1.2 DB. I tried to turn it off by putting “off” in
postgresql.cont file and restarted the postmaster but when I run “*show
autovacuum;* “ query I still see autovacuum set on inside the database.
autovacuum
---
oding for Postgres
9.1.2?
On 05/30/12 10:17 AM, Khangelani Gama wrote:
> So talking about compatibility, you are saying we can continue using
> UTF-8?, but this will create more work for us because most of our
> scripts assume that encoding is SQL_ASCII hence we want continue
> using SQL_
Postgres
9.1.2?
On Wed, May 30, 2012 at 11:58 PM, Khangelani Gama
wrote:
Hi
Please assist, I am junior DBA. We are upgrading from postgres 7.3.4 where
we were using SQL_ASCII Encoding to Postgres 9.1.2. It looks like Postgres
9.1.2 forces you to use UTF8 Encoding if I read from
SQL_ASCII in postgres 9.1.2?
Your help will bemuch appreciated.
Regards,
Khangelani Gama
CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addressee
only, and may contain the confidential information of Argility (Proprietary)
Limited and/or
63 matches
Mail list logo
