Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

Hi Tom, Please find my answers below. ->ulimit : Verified in file /etc/security/limits.conf - it has been configured as 2. Should I increase the limit and try again? please let me know. root - nofile 2 postgres - nofile 2 ->ssl_renegotiation_limit : Its been set as

Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

On 03/17/2017 12:27 AM, Sridevi B wrote: Ccing list. Please reply to list also, it puts more eyes on the problem. Hi Adrian, Sorry for delay. Please find my answers inline. Thanks, Sridevi On Thu, Mar 16, 2017 at 2:28 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 03

Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

Sridevi B writes: >I am facing an issue with backup/Restore for data size more than *2GB*. I'm suspicious that you're running into some limit external to postgres itself. A couple of likely possibilities: * maybe you've got a ulimit active on the server or the pg_dump or pg_restore proces.

Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

On 03/14/2017 09:48 AM, Sridevi B wrote: Hi , I am facing an issue with backup/Restore for data size more than *2GB*. Its working fine for *1GB*. Below are the details for issue: Description: The command pg_dump is hanging at saving large objects and process gets terminated after som

Re: [GENERAL] pg_dump/pg_restore issues

On 02/19/2014 10:32 AM, Leonardo M. Ramé wrote: On 2014-02-19 10:23:58 -0800, Adrian Klaver wrote: Another alternative would be to add another backup: pg_dump -s -t table1 -t table2 -f view.dump This will dump the table definitions only which is all you need. And then in order restore: vie

Re: [GENERAL] pg_dump/pg_restore issues

On 2014-02-19 10:23:58 -0800, Adrian Klaver wrote: > On 02/19/2014 10:08 AM, bricklen wrote: > > > >On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé > >mailto:l.r...@griensu.com>> wrote: > > > >Hi, I'm backing up a big database using the --exclude-table option for > >two tables, say table1

Re: [GENERAL] pg_dump/pg_restore issues

On 02/19/2014 10:08 AM, bricklen wrote: On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé > wrote: Hi, I'm backing up a big database using the --exclude-table option for two tables, say table1 and table2. Then another backup of only those tables, so, the

Re: [GENERAL] pg_dump/pg_restore issues

On 2014-02-19 10:08:19 -0800, bricklen wrote: > On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé wrote: > > > Hi, I'm backing up a big database using the --exclude-table option for > > two tables, say table1 and table2. Then another backup of only those > > tables, so, the final result are three

Re: [GENERAL] pg_dump/pg_restore issues

On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé wrote: > Hi, I'm backing up a big database using the --exclude-table option for > two tables, say table1 and table2. Then another backup of only those > tables, so, the final result are three backup files. > > basic.backup > table1.backup > table2.

Re: [GENERAL] PG_DUMP/PG_RESTORE duplicate Rows?

Never mind. I had my appserver up, and it probably screwed up. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -Original Message- From: pgsql-general-ow

Re: [GENERAL] pg_dump/pg_restore schema and data separately and foreign key constraints

On Tuesday 12 May 2009 2:35:10 pm Vasiliy Vasin wrote: > In the end, decided to make easier: make a complete dump except tables that > I don't want to backup, then just dump schema of these tables. So I have 2 > files: schema+data for all except table1 and table2, schema only for table1 > and table

Re: [GENERAL] pg_dump/pg_restore schema and data separately and foreign key constraints

Vasiliy Vasin wrote: I have database on production server that backups every day. Database is not big ~ 10mb. But I added several tables that takes big capacity and I don't want to backup data from them. So, I backup my database in two files: schema and data: pg_dump -s -E utf-8 -f ${filename.

Re: [GENERAL] pg_dump/pg_restore schema and data separately and foreign key constraints

In the end, decided to make easier: make a complete dump except tables that I don't want to backup, then just dump schema of these tables. So I have 2 files: schema+data for all except table1 and table2, schema only for table1 and table2. It's a strangely that pg_restore is still no option to che

Re: [GENERAL] pg_dump/pg_restore schema and data separately and foreign key constraints

On Tuesday 12 May 2009, Vasiliy Vasin wrote: > I have database on production server that backups every day. Database is > not big ~ 10mb. But I added several tables that takes big capacity and I > don't want to backup data from them. > > So, I backup my database in two files: schema and data: > pg

Re: [GENERAL] pg_dump/pg_restore schema and data separately and foreign key constraints

- "Vasiliy Vasin" wrote: > I have database on production server that backups every day. Database > is not big ~ 10mb. > But I added several tables that takes big capacity and I don't want to > backup data from them. > > So, I backup my database in two files: schema and data: > pg_dump -s -

Re: [GENERAL] pg_dump, pg_restore.

First, i apologize, my english skills is very, very poor. --- i have many tables in many schemas with default value like that: DEFAULT schema.function(...). i need backup all databases and i need restore it. IF YOU WANT UNDERSTAND ME, YOU NEED DO THIS: YOU TRY RESTORE _DB_TEST_.PGB FILE TO

Re: [GENERAL] pg_dump, pg_restore.

"Emil J." <[EMAIL PROTECTED]> writes: > Before pg_dump, default value is: ... DEFAULT moja_schema.fn_sq_id_kotuc() > ... > After pg_restore, default value is: ... DEFAULT fn_sq_id_kotuc() ... > The name of the scheme is missing, it is cut off. > I need first variant of default value (with nam

Re: [GENERAL] pg_dump.... pg_restore...how long does it take?

rafikoko <[EMAIL PROTECTED]> writes: > Could you please suggest me other compination of parameters for pg_dump, so > that it dumps complete database (inluding functions, triggers, procedures, > operators, sequences, tables, views etc. and obviously data)? > It doesn't have to be stored in .tar arch

Re: [GENERAL] pg_dump.... pg_restore...how long does it take?

Hi, Thanks for the answer. I've checked and the archive is corrupted. Every time I dump my database with pg_dump command mentioned in the previous post, I've got the same error. Could you please suggest me other compination of parameters for pg_dump, so that it dumps complete database (inluding

Re: [GENERAL] pg_dump.... pg_restore...how long does it take?

Hi, Thanks for the answer. I've checked and the archive is corrupted. Every time I dump my database with pg_dump command mentioned in the previous post, I've got the same error. Could you please suggest me other compination of parameters for pg_dump, so that it dumps complete database (inluding

Re: [GENERAL] pg_dump.... pg_restore...how long does it take?

Hi, Thanks for the answer. I've checked and the archive is corrupted. Every time I dump my database with pg_dump command mentioned in the previous post, I've got the same error. Could you please suggest me other compination of parameters for pg_dump, so that it dumps complete database (inluding

Re: [GENERAL] pg_dump.... pg_restore...how long does it take?

rafikoko <[EMAIL PROTECTED]> writes: > I've got also the following message after dumping: > pg_dump: [tar archiver] actual file length (4104361) does not match expected > (4104361) > which in fact does not make sense for me. Hmm, it looks like that code is printing the wrong variable's value. Howe

Re: [GENERAL] pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem

Thanks for the info! So its that easy, huh? =) I found a solution that worked but I don't know the effects yet. =) I noticed that it complained a lot about snb_ru_init function which apparently is not present in the new tsearch2.so file. So I removed the SP snb_ru_init() from my old database

Re: [GENERAL] pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem

Henrik -- I have only dabbled in tsearch2 so I can'toffer direct advise, but this looks like the problem when upgrading the postGIS stuff ... tsearch2 might have an upgrade functionality (postGIS does), but you can also do a more lbaorious method that strips out the unwanted tsearch2 definition

Re: [GENERAL] pg_dump & pg_restore suggestion

Hi, My wishlist for pg_{dump,restore} have only 1 item: 1) Thats "pg_restore -t file.bkp" returns not only the table, but the related PK and indexes, like "pg_dump -t makes with a operational database. If you drop a table from a database, this drops whole table and, obviously, your indexes. If

Re: [GENERAL] pg_dump, pg_restore

Basing on the way you did the pg_dump (without the -C option), I think you should have created the database before you performed the pg_restore, You can see some examples of database backup/restore in this page: http://nediam.com.mx/en/tips/backups_pgsql.php Regards, Javier On Mon, 6

Re: [GENERAL] pg_dump, pg_restore

Did you check if your pg_restore was successful? I think you need to include the following option while using pg_dump & pg_restore -C, --create include/issue commands to create database On 2/6/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote: > i am trying to do : > > pg_dump -f op.tar

Re: [GENERAL] pg_dump/pg_restore problems with 7.4.1

I can send you the test data, but it's confidential so I'll need to ask that you handle it carefully. Can you contact me off-list about this? I tried to send to your account directly but was bounced by your spam filter from both this and another account. Ben --- Tom Lane <[EMAIL PROTECTED]> wro