pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump question...
10+ messages / 10 participants
[nested] [flat]
* pg_dump question...
@ 2000-01-30 07:43 Brad Bonkoski <bbc1049@saintjoe.edu>
0 siblings, 0 replies; 10+ messages in thread
From: Brad Bonkoski @ 2000-01-30 07:43 UTC (permalink / raw)
To: pgsql-admin
Hello..
I have password authentication going on my DB, and everything works
quite well except for this command:
pg_dump -u <db_name> > dumpfile
it just hangs.... but when I run pg_dump -u <db_name> it will print all
the stuff out to me, so I assume it must be with putting it into a
file. Does anyone have any suggestions on this?
TIA.
-Brad
^ permalink raw reply [nested|flat] 10+ messages in thread
* pg_dump question
@ 2002-10-29 01:26 Tom Haddon <tom@haddons.net>
0 siblings, 2 replies; 10+ messages in thread
From: Tom Haddon @ 2002-10-29 01:26 UTC (permalink / raw)
To: pgsql-admin
Hi Folks,
Fairly basic question here, I think. I've looked through the archives, but
can't seem to find anything.
I need to set up a daily cron job that performs a pg_dump on a remote
database. I can't figure out how to pass a password to it. How do I do
this. Everything I've tried still comes up with asking me for a password
when I test it.
Thanks, Tom
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_dump question
@ 2002-10-29 01:38 Aaron Spiteri <aaron@m1group.com.au>
parent: Tom Haddon <tom@haddons.net>
1 sibling, 0 replies; 10+ messages in thread
From: Aaron Spiteri @ 2002-10-29 01:38 UTC (permalink / raw)
To: pgsql-admin
One way is to do this is by configuring the remote server to trust the host
that is going to be doing the back up. This can be done in the pg_hba.conf
file which is located in "/var/lib/pgsql/data" on my server.
If the Server that is going to be doing the back up has the IP address of say
192.168.0.2 and then on the database server you can add the following lines
host all 192.168.0.2 255.255.255.255 trust
host all 0.0.0.0 255.255.255.255 password
This will allow the server 192.168.0.2 to access any database it likes
remotly without needing a password. Usename must be valid however.
This can also specify what database the host can access by changing the
key word "all" to the database name.
host template1 192.168.0.2 255.255.255.255 trust
There are possibly much more secure wats to do this and if you here of any
let me know.
Aaron
On Tue, 29 Oct 2002 12:26, you wrote:
> Hi Folks,
>
> Fairly basic question here, I think. I've looked through the archives, but
> can't seem to find anything.
>
> I need to set up a daily cron job that performs a pg_dump on a remote
> database. I can't figure out how to pass a password to it. How do I do
> this. Everything I've tried still comes up with asking me for a password
> when I test it.
>
> Thanks, Tom
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_dump question
@ 2002-10-29 04:35 Bhuvan A <bhuvansql@myrealbox.com>
parent: Tom Haddon <tom@haddons.net>
1 sibling, 0 replies; 10+ messages in thread
From: Bhuvan A @ 2002-10-29 04:35 UTC (permalink / raw)
To: pgsql-admin
> I need to set up a daily cron job that performs a pg_dump on a remote
> database. I can't figure out how to pass a password to it. How do I do
> this. Everything I've tried still comes up with asking me for a password
> when I test it.
>
$ export PGPASSWORD=user_pass
$ echo -e "Would do the trick. Yes, it will not ask for the password
again";
regards,
bhuvaneswaran
^ permalink raw reply [nested|flat] 10+ messages in thread
* PG_DUMP Question
@ 2003-10-29 13:43 Alex <alex@meerkatsoft.com>
0 siblings, 0 replies; 10+ messages in thread
From: Alex @ 2003-10-29 13:43 UTC (permalink / raw)
To: pgsql-admin
Hi,
I have a test system that is setup the same as a production system and
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.
Are there any reasons not to simply just copy the entire data directory
over to the test system? I could not find any postings on the net
suggesting otherwise. Is there anything to pay attention too ?
Thanks for any advise
Alex
^ permalink raw reply [nested|flat] 10+ messages in thread
* pg_dump question
@ 2004-11-02 14:17 Andrei Bintintan <klodoma@ar-sd.net>
0 siblings, 1 reply; 10+ messages in thread
From: Andrei Bintintan @ 2004-11-02 14:17 UTC (permalink / raw)
To: pgsql-admin
Hi to all,
If I create a table with create table and after that I modify the table(add some columns) in the dump the table is saved in the same way, I mean, in the dump first the table is created and after that the column is added.
Is there a possibility to dump the database and the table structure to be saved as "it is" or always it will be dumped as created and after that altered?
Andy.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_dump question
@ 2004-11-03 21:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: Andrei Bintintan <klodoma@ar-sd.net>
0 siblings, 0 replies; 10+ messages in thread
From: Tom Lane @ 2004-11-03 21:19 UTC (permalink / raw)
To: Andrei Bintintan <klodoma@ar-sd.net>; +Cc: pgsql-admin
"Andrei Bintintan" <klodoma@ar-sd.net> writes:
> If I create a table with create table and after that I modify the =
> table(add some columns) in the dump the table is saved in the same way, =
> I mean, in the dump first the table is created and after that the column =
> is added.=20
I don't actually believe that --- simple inspection of the pg_dump
source shows that it can never emit an ALTER TABLE ADD COLUMN command.
Can you give a concrete example of what you are talking about?
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* pg_dump question
@ 2006-08-07 13:12 Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
0 siblings, 0 replies; 10+ messages in thread
From: Srinivas Iyyer @ 2006-08-07 13:12 UTC (permalink / raw)
To: pgsql-admin
*** Apologies for re-posting this e-mail ****
Dear group,
I have a strange problem. apologies if this is the
wrong place, however as a first option i am posting
here. I have to subscribe to other special mailing
lists.
I have two databases in my system.
In firstdb i am having the following problem:
firstdb=# \d targets
ERROR: could not access status of transaction 362
DETAIL: could not open file
"/var/lib/pgsql/data/pg_clog/0000": No such file or
directory
when I vacuumed it:
$ vacuumdb firstdb
vacuumdb: vacuuming of database "firstdb" failed:
ERROR: could not access status of transaction 11
DETAIL: could not open file
"/var/lib/pgsql/data/pg_clog/0000": No such file or
directory
Second problem:
Issue with secondb - arraydb
$ vacuumdb arraydb
VACUUM
Suspecting there is something going on with postgres,
I wanted to take a backup of the arraydb.
here is what I am doing:
$ sudo pg_dump arraydb > arraydb_bcup_Aug_05_2006.dump
$ ls -lh
total 8.0K
-rw-r--r-- 1 speri postgres 0 Aug 5 20:17
arradb_bcup_Aug_05_2006.out
There is nothing in this. I created dumps long back
and they are heavy.
what could be the problem in the cases of first and
second problems.
looking forward to hear from experts eagerly.
Thanks
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* pg_dump question
@ 2007-12-07 20:18 Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 10+ messages in thread
From: Carol Walter @ 2007-12-07 20:18 UTC (permalink / raw)
To: pgsql-admin
Hello-
I'm trying to do an upgrade of version 8.1 to 8.2.3. The restore is
failing because of some code that is in some views. If I dump the
just the schema and then dump just the data, will the views be included?
Carol
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: pg_dump question
@ 2007-12-07 20:36 Scott Marlowe <scott.marlowe@gmail.com>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 10+ messages in thread
From: Scott Marlowe @ 2007-12-07 20:36 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
On Dec 7, 2007 2:18 PM, Carol Walter <walterc@indiana.edu> wrote:
> Hello-
>
> I'm trying to do an upgrade of version 8.1 to 8.2.3. The restore is
> failing because of some code that is in some views. If I dump the
> just the schema and then dump just the data, will the views be included?
Well, that really kinda depends.
Are you pg_dumping with 8.2's pg_dump? If not try that.
What exact error messages are you getting?
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2007-12-07 20:36 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-30 07:43 pg_dump question... Brad Bonkoski <bbc1049@saintjoe.edu>
2002-10-29 01:26 pg_dump question Tom Haddon <tom@haddons.net>
2002-10-29 01:38 ` Re: pg_dump question Aaron Spiteri <aaron@m1group.com.au>
2002-10-29 04:35 ` Re: pg_dump question Bhuvan A <bhuvansql@myrealbox.com>
2003-10-29 13:43 PG_DUMP Question Alex <alex@meerkatsoft.com>
2004-11-02 14:17 pg_dump question Andrei Bintintan <klodoma@ar-sd.net>
2004-11-03 21:19 ` Re: pg_dump question Tom Lane <tgl@sss.pgh.pa.us>
2006-08-07 13:12 pg_dump question Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
2007-12-07 20:18 pg_dump question Carol Walter <walterc@indiana.edu>
2007-12-07 20:36 ` Re: pg_dump question Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox