Re: [SQL] pg_dump: aborting because of server version mismatch

On 05/02/2012 12:55 PM, Mitesh Shah wrote: Hi, I am trying to create a daily backup cron script but it fails with an error as below: Any pointers to resolve this will be greatly appreciated. Thanks, Mitesh Shah mitesh.s...@stripes39.com *(1) Error:* bash-3.2$

[SQL] pg_dump: aborting because of server version mismatch

Hi, I am trying to create a daily backup cron script but it fails with an error as below: Any pointers to resolve this will be greatly appreciated. Thanks, Mitesh Shah mitesh.s...@stripes39.com *(1) Error:* bash-3.2$ sh pg_backup_rotated_orig.sh Making backup directory in /Users/miteshshah/Docum

[SQL] pg_dump : no tables were found.

Hi, I m trying to take backup of data of a particular table using pg_dump. I used double quotes for table name but output is : pg_dump : no tables were found. Command used : -h localhost -p 5432 -U postgres -W -F p -a -t '"TestTable"' -f DbBackup/BackupTableActions.sql TestDataBase This problem

Re: [SQL] pg_dump - 8.3 - schemas

On 02/16/2012 12:17 PM, Edward W. Rouse wrote: Well, when I do a restore using the created file, reports isn't there. i.e. the select from reports.table gives an error and, from psql, \l doesn't list it and \dn doesn't show it. But that all does work on the original database. What is the error

Re: [SQL] pg_dump - 8.3 - schemas

-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of Adrian Klaver > Sent: Thursday, February 16, 2012 2:39 PM > To: Edward W. Rouse > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] pg_dump - 8.3 - schemas > > On 02/16/2012 11:31 AM, Edward W. Rous

Re: [SQL] pg_dump - 8.3 - schemas

On 02/16/2012 11:31 AM, Edward W. Rouse wrote: To answer the second question first, yes; both as the same user. pg_dump -v -f $bkfile -F c -U $USER $DATABASE So how are you determining that only the public schema is being dumped? One thing to check is the search_path setting in postgresql.con

Re: [SQL] pg_dump - 8.3 - schemas

@postgresql.org > Subject: Re: [SQL] pg_dump - 8.3 - schemas > > On 02/16/2012 10:59 AM, Edward W. Rouse wrote: > > I am working with a database set up by someone else. They set it up > so that > > most tables are in the public schema, but they also have a reports &

Re: [SQL] pg_dump - 8.3 - schemas

On 02/16/2012 10:59 AM, Edward W. Rouse wrote: I am working with a database set up by someone else. They set it up so that most tables are in the public schema, but they also have a reports schema; database.public.tables and database.reports.tables. If I do a pg_dump of the database, I only get

[SQL] pg_dump - 8.3 - schemas

I am working with a database set up by someone else. They set it up so that most tables are in the public schema, but they also have a reports schema; database.public.tables and database.reports.tables. If I do a pg_dump of the database, I only get the public schema. If I do a dump with --schema=r

Re: Fw: Re: [SQL] pg_dump not correctly saving schema with partitioned tables?

chester c young writes: >> here is a test case: [ slightly less messed-up test case for anyone who wants to duplicate this: ] create schema s1; create schema s2; create table s1.t1( c1 bigserial primary key, c2 text ); create table s2.t1( c1 bigserial primary key ) inherits( s1

Fw: Re: [SQL] pg_dump not correctly saving schema with partitioned tables?

> From: chester c young > Subject: Re: [SQL] pg_dump not correctly saving schema with partitioned > tables? > To: "Tom Lane" > Date: Tuesday, January 31, 2012, 5:40 PM > --- On Tue, 1/31/12, Tom Lane > wrote: > > > From: Tom Lane > > Subject:

Re: [SQL] pg_dump not correctly saving schema with partitioned tables?

chester c young writes: > have database with many partitions. each partition table has its own primary > key sequence. >Column || Modifiers > ---++-- > uno_id|| not n

[SQL] pg_dump not correctly saving schema with partitioned tables?

have database with many partitions. each partition table has its own primary key sequence. Column || Modifiers ---++-- uno_id|| not null default nextval('cmp0004.cmt_u

Re: [SQL] pg_dump : problem with grant on table columns

On Nov 15, 2011 9:46 PM, "Brice André" wrote: > > Hello, > > I sometimes define some access rights on table columns instead of whole table. Everything works fine except when I perform a dump. > > When I dump a databse that contains such access rights, the pg_dump utility generates commands like th

[SQL] pg_dump : problem with grant on table columns

Hello, I sometimes define some access rights on table columns instead of whole table. Everything works fine except when I perform a dump. When I dump a databse that contains such access rights, the pg_dump utility generates commands like this one : GRANT SELECT("Login") ON TABLE "Clients" TO "Age

Re: [SQL] pg_dump more than one table in one command?

Looks like you are right, Scott. Thanks! I wasn't in Postgres land back then. On Mon, Oct 6, 2008 at 5:48 PM, Scott Marlowe <[EMAIL PROTECTED]>wrote: > On Mon, Oct 6, 2008 at 3:24 PM, Harold A. Giménez Ch. > <[EMAIL PROTECTED]> wrote: > > > > On Mon, Oct 6, 2008 at 5:02 PM, Emi Lu <[EMAIL PROTECT

Re: [SQL] pg_dump more than one table in one command?

On Mon, Oct 6, 2008 at 3:24 PM, Harold A. Giménez Ch. <[EMAIL PROTECTED]> wrote: > > On Mon, Oct 6, 2008 at 5:02 PM, Emi Lu <[EMAIL PROTECTED]> wrote: >> >> Good morning, >> >> Under postgreSQL 8.0, could someone tell me how to pg_dump more than one >> tables at the same time please? >> >> I tried

Re: [SQL] pg_dump more than one table in one command?

You must specify --table (or -t) once for each of the tables, ie: pg_dump -h machineName -U username --inserts --column-inserts --file=dump.sql --table=t1 --table=t2 . . --table=tN -d databaseName ; -t t1 -t t2 -t t3 On Mon, Oct 6, 2008 at 5:02 PM, Emi Lu <[EMAIL PROTECTED]> wrote: > Go

[SQL] pg_dump more than one table in one command?

Good morning, Under postgreSQL 8.0, could someone tell me how to pg_dump more than one tables at the same time please? I tried to do something like: pg_dump -h machineName -U username --inserts --column-inserts --file=dump.sql --table=t1 t2 ... ...tN -d databaseName ; Thanks a lot! -- Sen

Re: [SQL] pg_dump in windows

mbara.   ORGINAL MESSAGE-- --- On Fri, 19/9/08, Ramasubramanian <[EMAIL PROTECTED]> wrote: From: Ramasubramanian <[EMAIL PROTECTED]> Subject: [SQL] pg_dump in windows To: pgsql-sql@postgresql.org

Re: [SQL] pg_dump in windows

Ramasubramanian wrote: > HI all, I am facing a problem while taking a back up in windows. It > is asking for a password while using pg_dump. Why it is asking for a > password ?(it is not asking password in linux) Give some details > about fe_sendauth in postgres . How i can avoid asking password in

[SQL] pg_dump in windows

HI all, I am facing a problem while taking a back up in windows. It is asking for a password while using pg_dump. Why it is asking for a password ?(it is not asking password in linux) Give some details about fe_sendauth in postgres . How i can avoid asking password in windows shile taking bac

Re: [SQL] pg_dump and "could not identify an ordering operator for type name"

Gerardo Herzig escribió: Hi dudes. Im facing a problem with pg_dump, pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not identify an ordering operator for type name HINT: Use an explicit ordering operator or modify the query. pg_dump: The command was: SELECT t.tabl

[SQL] pg_dump and "could not identify an ordering operator for type name"

Hi dudes. Im facing a problem with pg_dump, pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not identify an ordering operator for type name HINT: Use an explicit ordering operator or modify the query. pg_dump: The command was: SELECT t.tableoid, t.oid, t.relname as i

Re: [SQL] pg_dump using SQL

Yusnel Rojas Garc?a([EMAIL PROTECTED])@2008.03.18 11:45:03 -0800: > Hi everyone > > Is there any way to do what pg_dump does?, I mean, get the structure of a > table in a database (ex: CREATE TABLE ...) > If you want to programmaticly discover the elements in a database schema then you can alway

Re: [SQL] pg_dump using SQL

"Phillip Smith" <[EMAIL PROTECTED]> writes: >> Is there any way to do what pg_dump does?, I mean, get the structure of a >> table in a database (ex: CREATE TABLE ...) > Turn Query Logging on in postgresql.conf then see what queries are executed > by pgAdmin or similar when you run it? But note th

Re: [SQL] pg_dump using SQL

> Is there any way to do what pg_dump does?, I mean, get the structure of a table in a database (ex: CREATE TABLE ...) Turn Query Logging on in postgresql.conf then see what queries are executed by pgAdmin or similar when you run it? THINK BEFORE YOU PRINT - Save paper if you don't really need t

[SQL] pg_dump using SQL

Hi everyone Is there any way to do what pg_dump does?, I mean, get the structure of a table in a database (ex: CREATE TABLE ...) thanks in advance.

Re: [SQL] pg_dump question

On Oct 5, 2007, at 11:58 AM, Judith wrote: Hello every body!! I have a quesyion respect pg_dump... I need to backup the db structure, I suposse that I do with pg_dump -s, but I want to restore but just with some tables with the db catalogues, can I do this?, I mean, restore al

[SQL] pg_dump question

Hello every body!! I have a quesyion respect pg_dump... I need to backup the db structure, I suposse that I do with pg_dump -s, but I want to restore but just with some tables with the db catalogues, can I do this?, I mean, restore al the db structure without data and after restor

Re: [SQL] pg_dump?

You want to look at the pg_dump command. A On Mon, May 14, 2007 at 03:48:17PM -0700, Richard Dunne wrote: > PostgreSQL begginer. Whats the best way of exporting(dumping) a > database/table/view/query to a file? > I am using PostgreSQL v 8.2. I am starting postgres server with > C:\WINDOWS\sys

Re: [SQL] pg_dump?

Richard Dunne wrote: PostgreSQL begginer. Whats the best way of exporting(dumping) a database/table/view/query to a file? I am using PostgreSQL v 8.2. I am starting postgres server with C:\WINDOWS\system32\net.exe start pgsql-8.2, (start service) C:\postgresql-8.2.3-1\bin\psql.exe -h localhos

[SQL] pg_dump?

PostgreSQL begginer. Whats the best way of exporting(dumping) a database/table/view/query to a file? I am using PostgreSQL v 8.2. I am starting postgres server with C:\WINDOWS\system32\net.exe start pgsql-8.2, (start service) C:\postgresql-8.2.3-1\bin\psql.exe -h localhost -p 5432 postgres "R

Re: [SQL] pg_dump inquiry

On Thu, 2007-03-01 at 12:30 -0300, Osvaldo Rosario Kussama wrote: > http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html > "Multiple tables can be selected by writing multiple -t switches. Also, > the table parameter is interpreted as a pattern according to the same > rules used by psql

Re: [SQL] pg_dump inquiry

Karthikeyan Sundaram escreveu: Hi, I have to dump only 10 tables out of 100 tables. In the pg_dump utility given by postgres there is an option called -t followed by table name. In that option, if I give more than 1 table, it's not accepting. How can I get the dump in one stroke fo

[SQL] pg_dump inquiry

Hi, I have to dump only 10 tables out of 100 tables. In the pg_dump utility given by postgres there is an option called -t followed by table name. In that option, if I give more than 1 table, it's not accepting. How can I get the dump in one stroke for all the 10 tables? Please advi

[SQL] pg_dump error

Hi, I am using 8.2.1 on my dev server. When I do a pg_dump, I am getting an error message. pg_dump -U postgres podcast -t channel pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn How can I resolved this? What may be the problem? Because of this, I am no

Re: [SQL] pg_dump fails (timestamp out of range)

Andrew Sullivan wrote: On Mon, Feb 26, 2007 at 11:05:08AM +, T E Schmitz wrote: I can't thank you enough for the above advice. The test above identified 3 records and once they were removed I was able to dump the DB. You'll be wanting to make sure your hardware is fixed after this, don't

Re: [SQL] pg_dump fails (timestamp out of range)

On Mon, Feb 26, 2007 at 11:05:08AM +, T E Schmitz wrote: > I can't thank you enough for the above advice. The test above identified > 3 records and once they were removed I was able to dump the DB. You'll be wanting to make sure your hardware is fixed after this, don't forget, or you'll end

Re: [SQL] pg_dump fails (timestamp out of range)

Tom Lane wrote: T E Schmitz <[EMAIL PROTECTED]> writes: pg_dump: ERROR: timestamp out of range pg_dump: SQL command to dump the contents of table "server_hit_bin" failed: PQendcopy() failed. You should treat this as a corrupt-data exercise: you need to identify and fix (or delete) the offen

Re: [SQL] pg_dump fails (timestamp out of range)

T E Schmitz <[EMAIL PROTECTED]> writes: > However, I am stalled because pg_dump fails with the following error: > pg_dump: ERROR: timestamp out of range > pg_dump: SQL command to dump the contents of table "server_hit_bin" > failed: PQendcopy() failed. You should treat this as a corrupt-data exe

[SQL] pg_dump fails (timestamp out of range)

Apologies for cross-posting (already sent to pgadmin-support) but I am totally stuck with this: I run an ecommerce system on a webserver, which I want to move to a different machine. However, I am stalled because pg_dump fail

Re: [SQL] pg_dump

"M. Santosa" <[EMAIL PROTECTED]> writes: > I've install postgres in linux. > but pg_dump its not working at all. > -bash-3.00$ psql -l > ERROR: relation "pg_catalog.pg_user" does not exist IIRC, this is a symptom of selinux having interfered with initdb. Get a newer copy of the selinux policy pac

Re: [SQL] pg_dump

On Tue, Sep 05, 2006 at 02:22:29PM +0700, M. Santosa wrote: > and if i execute the psql with list database option, the result is error > > -bash-3.00$ psql -l > ERROR: relation "pg_catalog.pg_user" does not exist This looks to me like you have more than one postmaster installed, and you've got

[SQL] pg_dump

I've install postgres in linux. but pg_dump its not working at all. if i execute the pg_dump to the file like this pg_dump -Upostgres -dpostgres > file.dmp the file file.dmp is empty and if i execute the psql with list database option, the result is error -bash-3.00$ psql -l ERROR: relation

Re: [SQL] pg_dump and diffrent sizes

On Fri, 2006-03-03 at 14:10, Maciej Piekielniak wrote: > Hello pgsql-sql, > > I dump db with pg_dump v.8.1.3 on database postgresql server 7.4.7. > Data directory with my db on pg 7.4.7 had 1,8GB and > file with dump had 2,7GB. > Database have blob fields. > > When I restore db on pg 8.1 - data d

[SQL] pg_dump and diffrent sizes

Hello pgsql-sql, I dump db with pg_dump v.8.1.3 on database postgresql server 7.4.7. Data directory with my db on pg 7.4.7 had 1,8GB and file with dump had 2,7GB. Database have blob fields. When I restore db on pg 8.1 - data directory have only 1GB, why? -- Best regards, Maciej

Re: [SQL] pg_dump

On Fri, 2005-11-11 at 17:04 -0600, Judith Altamirano Figueroa wrote: > Hi > > how could I restore a db if I did next: > > pg_dump -Z 9 soi > $DESTINO/soi.bkp Since you don't specify any dump format, your dump should be plain text and is compressed with gzip, so the restore command is going t

[SQL] pg_dump

Hi how could I restore a db if I did next:     pg_dump -Z 9 soi > $DESTINO/soi.bkp Thanks in advanced

Re: [SQL] pg_dump without data

On Fri, 2005-05-06 at 04:14, Kenneth Gonsalves wrote: > how do i get a dump of a postgresql database without the data? pg_dump -s for the schema pg_dumpall -g for the globals, like usernames and all. ---(end of broadcast)--- TIP 4: Don't 'kill -9'

Re: [SQL] pg_dump without data

how do i get a dump of a postgresql database without the data? % pg_dump --help pg_dump dumps a database as a text file or to other formats. Usage: pg_dump [OPTION]... [DBNAME] . -s, --schema-onlydump only the schema, no data -philip ---(end of broadcast

[SQL] pg_dump without data

how do i get a dump of a postgresql database without the data? -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.sourceforge.net àà à! ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] pg_dump/pg_restore question

Worik wrote: Freinds I am new to this list, and this is my first message. I hope this is the correct forum, and the question not too stupid/simple. I have a database on a debian stable system... dpkg -l postgresql [snip] ii postgresql 7.2.1-2woody5 Object-relational SQL database, descended f

Re: [SQL] pg_dump/pg_restore question

EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 11:59 AM Subject: [SQL] pg_dump/pg_restore question > Freinds > > I am new to this list, and this is my first message. > > I hope this is the correct forum, and the question not too stupid/simple.

[SQL] pg_dump/pg_restore question

Freinds I am new to this list, and this is my first message. I hope this is the correct forum, and the question not too stupid/simple. I have a database on a debian stable system... dpkg -l postgresql [snip] ii postgresql 7.2.1-2woody5 Object-relational SQL database, descended fr When I dum

[SQL] pg_dump backwards compat issues

Hi all, anybody have a sed script (or flags for pg_dump) that will make a pg_dump 7.4 dump load into a Pg 7.3.x backend? TIA! --- Thomas Good e-mail: [EMAIL PROTECTED] Programmer/Analyst

[SQL] pg_dump error - Permission denied

Dear friends,   I am working with Postgres 7.3.4 on RH Linux 7.3.   I could manage to take a backup using the following command and as the user 'postgres'.  $ pg_dump -h 192.168.2.51 -v -u -f /home/db_repository/test20031103.sql test   But while I try to execute the same command with the user

Re: [SQL] pg_dump "feature"

m: "Tom Lane" <[EMAIL PROTECTED]> To: "Viorel Dragomir" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 5:29 PM Subject: Re: [SQL] pg_dump "feature" > "Viorel Dragomir" <[EMAIL PROTECTED]> writes: > >

Re: [SQL] pg_dump "feature"

"Viorel Dragomir" <[EMAIL PROTECTED]> writes: > In 7.3.x the pg_dump accepts the password only from stdin. The user must en= > ter his password. > It's a feature or a bug, because i can't see any logic in this behaviour. It's a feature ... or at least an intentional change. If you want to keep yo

[SQL] pg_dump "feature"

In 7.1.2 you can launch this command without any problems: pg_dump -u -s database < file.txt   where file.txt contains 2 lines: username password ~ ~ ~   And you'll get the dump of the .   In 7.1.3 this command work, the only incovenience is that pg_dump shows "User name: Password:" but get

Re: [SQL] pg_dump problem

> mv camper.dump20020116 camper_bak/ > > The error I get is :: > > mv: camper.dump20020116: Value too large for defined data type > It may not be a postgresql problem. It may be due to your filesystem. Try the documentation or mailing list of your filesystem. regards, bhuvaneswaran ---

Re: [SQL] pg_dump problem

Rudi Starcevic wrote: Hi, After doing a pg_dump on a database I'm unable to access the file. My command is simply 'mv' :: mv camper.dump20020116 camper_bak/ The error I get is :: mv: camper.dump20020116: Value too large for defined data type Strange. It seems to be saying the file I created

[SQL] pg_dump problem

Hi, After doing a pg_dump on a database I'm unable to access the file. My command is simply 'mv' :: mv camper.dump20020116 camper_bak/ The error I get is :: mv: camper.dump20020116: Value too large for defined data type Strange. It seems to be saying the file I created is too large to handle.

[SQL] pg_dump / dates:

Question for Tom Lockhart: pg_dump is generating some dates that look like: '2002-09-09 02:11:60.00' or '2002-10-31 23:59:60.00'. psql -f doesn't like these dates. I can sed the :60 to a :59 but -- in the latter case it moves the date backwards a day, which doesn't work for my app. I underst

Re: [SQL] pg_dump, no inserts but \copy?

There is no way to force INSERT unless you are telling it to do that somehow. Are you perhaps using -d. That causes inserts too? What is your command line for the dump? --- Joost Witteveen wrote: > I remember the pg_dump

[SQL] pg_dump, no inserts but \copy?

I remember the pg_dump command creating dumps with \copy in them But for some reason (upgrade of postgresql?) it now started to create dumps with inserts, as though I gave it the --inserts argument (but I don't). man pg_dump explains how to make it use inserts, but I cannot find anywhere how to ma

Re: [SQL] pg_dump and sequences

On Wed, 24 Jul 2002, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > >> It seems that pg_dump -t "tablename" dumps correctly the sequence of a > >> table's column,when the column is named after "id". > > > I meant "when ONLY" the column is named after "id", > > Yeah, you're

Re: [SQL] pg_dump and sequences

Achilleus Mantzios <[EMAIL PROTECTED]> writes: >> It seems that pg_dump -t "tablename" dumps correctly the sequence of a >> table's column,when the column is named after "id". > I meant "when ONLY" the column is named after "id", Yeah, you're right. I'm hoping to see a better answer in 7.3, bu

Re: [SQL] pg_dump and sequences

On Tue, 23 Jul 2002, Achilleus Mantzios wrote: Just a correction > Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel > 2.4.9-31,glibc-2.2.4-24). > > It seems that pg_dump -t "tablename" dumps correctly the sequence of a > table's column,when the column is named after "id". >

[SQL] pg_dump and sequences

Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel 2.4.9-31,glibc-2.2.4-24). It seems that pg_dump -t "tablename" dumps correctly the sequence of a table's column,when the column is named after "id". For example, dynacom=# CREATE TABLE foo2 (fid serial NOT NULL UNIQUE PRIMARY KEY,id ser

Re: [SQL] pg_dump bug? (7.1)

Cedar Cox <[EMAIL PROTECTED]> writes: > When I try to run pg_dump I get a segmentation fault. This only seems to > happen if the PGDATABASE environment variable is set and I don't supply > the database name on the command line. Fixed. regards, tom lane -

[SQL] pg_dump bug? (7.1)

Well, I finally decided to play around with 7.1. Here's the problem: When I try to run pg_dump I get a segmentation fault. This only seems to happen if the PGDATABASE environment variable is set and I don't supply the database name on the command line. If I unset PGDATABASE, I get a normal e

[SQL] pg_dump and BLOB

Hello, I am using postgreSQL 7.02 on RH Linux 6.2. I have noticed that dumping out a table containing oid (BLOBs) makes trouble. How can I managed this in order to have my BLOBs backed up correctly ? If I don't take care, I have a table with oid that don't point on any object id (relation does no

[SQL] pg_dump and oid

Hello, I am using postgreSQL 7.02 on RH Linux 6.2. I have noticed that dumping out a table containing oid (BLOBs) makes trouble. How can I managed this in order to have my BLOBs backed up correctly ? If I don't take care, I have a table with oid that don't point on any object id (relation does n

[SQL] pg_dump error plus RelationBuildTriggers: 1 record(s) not found for rel links

Hi all, here is error I that am getting: pg_dump -s mondo > mondo.out PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 I faced similar example in the past too. At that time, there was a referentional constraint problem but this situation is different. I am usning postgres 7.0.3 on redh

[SQL] pg_dump question

When dumping database, is it possible to dump datetime values without the timezone info? I'm currentlyl using 6.5.

Re: [SQL] pg_dump error - further information

On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: > I would guess that this means there is a file named "pgdump_oid" hanging > around in the database directory, no doubt leftover from some previous > pg_dump cycle. Manually removing the file should get you up and running > again. However

Re: [SQL] pg_dump error

On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: > Tatsuo Ishii <[EMAIL PROTECTED]> writes: > Can not create pgdump_oid table. Explanation from backend: 'ERROR: > cannot create pgdump_oid > > Is there a way to repair this? > > I would guess that this means there is

Re: [SQL] pg_dump error

Tatsuo Ishii <[EMAIL PROTECTED]> writes: Can not create pgdump_oid table. Explanation from backend: 'ERROR: cannot create pgdump_oid Is there a way to repair this? I would guess that this means there is a file named "pgdump_oid" hanging around in the database directory, no d

Re: [SQL] pg_dump error

> >Can not create pgdump_oid table. Explanation from backend: 'ERROR: > >cannot create pgdump_oid > > > >Is there a way to repair this? > > > > If there was an earlier crash while running pg_dump, the table may already > exist. If so, try deleting it. Also, can you confirm that the username > un

Re: [SQL] pg_dump error

At 22:13 15/01/01 +0200, Johann Spies wrote: > >Can not create pgdump_oid table. Explanation from backend: 'ERROR: >cannot create pgdump_oid > >Is there a way to repair this? > If there was an earlier crash while running pg_dump, the table may already exist. If so, try deleting it. Also, can you

[SQL] pg_dump error

Version 6.5.3 on Debian Potato My daily cron job reported : Can not create pgdump_oid table. Explanation from backend: 'ERROR: cannot create pgdump_oid Is there a way to repair this? Johann -- J.H. Spies - Tel. 082 782 0336 "For I know that my redeemer liveth, and that he shall

Re: [SQL] pg_dump Error

Najm Hashmi <[EMAIL PROTECTED]> writes: > while trying to dump db shcema and content, I am getting the > following error: > [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql > PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 > Segmentation fault (core dumped) Hmm, look

[SQL] pg_dump Error

Hi all, while trying to dump db shcema and content, I am getting the following error: [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 Segmentation fault (core dumped) Any suggestion what I am doing wrong and why i am

Re: [SQL] pg_dump

sathya priya <[EMAIL PROTECTED]> writes: > when dump the database it throw > "getTables(): relation 'ordermaster': cannot find > function with oid 1655 for trigger > RI_ConstraintTrigger_2017354 " I think this must be another variant of the 6.5-pg_dump-with-7.0-database problem. There's no err

[SQL] pg_dump

hai when dump the database it throw "getTables(): relation 'ordermaster': cannot find function with oid 1655 for trigger RI_ConstraintTrigger_2017354 " any clues thank advance p. ashok kumar __ Do You Yahoo!? Get Yahoo! Mail – Free email you

Re: [SQL] pg_dump problem

Ed Loehr wrote: > > Graham Vickrage wrote: > > > > I am trying to backup a production database running on v6.5 and restore it > > on our test machine running v6.5. > > > > The largest table has about 750,000 rows, the other 5 tables are very small > > approx 100 rows. > > > > When I try to restor

Re: [SQL] pg_dump problem

Graham Vickrage wrote: > > I am trying to backup a production database running on v6.5 and restore it > on our test machine running v6.5. > > The largest table has about 750,000 rows, the other 5 tables are very small > approx 100 rows. > > When I try to restore the database using "psql -e dat

[SQL] pg_dump problem

I am trying to backup a production database running on v6.5 and restore it on our test machine running v6.5. The largest table has about 750,000 rows, the other 5 tables are very small approx 100 rows. When I try to restore the database using "psql -e database < db.out" I get the error message