pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump
7+ messages / 5 participants
[nested] [flat]
* pg_dump
@ 2005-06-14 22:34 enzo venegas palacios <enzovenegas@mixmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: enzo venegas palacios @ 2005-06-14 22:34 UTC (permalink / raw)
To: pgsql-php
hi, i don't know use the pg_dump instruccion and i need create a backup,
please someone has an example.
thanks
enzo
---------------------------------------------------------
Imagina tus vacaciones perfectas... y hazlas realidad. Juega en http://sorteos.ya.com
ADSL + Llamadas 24 horas: desde 28,95 /mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_dump
@ 2005-06-15 01:24 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: enzo venegas palacios <enzovenegas@mixmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Christopher Kings-Lynne @ 2005-06-15 01:24 UTC (permalink / raw)
To: enzovenegas@mixmail.com; +Cc: pgsql-php
pg_dumpall <dbname> > backup.sql
Chris
enzo venegas palacios wrote:
> hi, i don't know use the pg_dump instruccion and i need create a backup,
> please someone has an example.
> thanks
> enzo
> ---------------------------------------------------------
>
> Imagina tus vacaciones perfectas... y hazlas realidad. Juega en http://sorteos.ya.com
> ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_dump
@ 2005-06-15 15:27 operationsengineer1@yahoo.com
parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 1 reply; 7+ messages in thread
From: operationsengineer1@yahoo.com @ 2005-06-15 15:27 UTC (permalink / raw)
To: pgsql-php
i read that you can copy the contents of pgsql's data
directory to create a backup, too. in order to
restore the db, you clean out the data directory and
then copy the "backed up" files back in to the data
directory.
i have no experience using this method, but i thought
i'd mention it to see if anyone else has done this.
--- Christopher Kings-Lynne
<chriskl@familyhealth.com.au> wrote:
> pg_dumpall <dbname> > backup.sql
>
> Chris
>
> enzo venegas palacios wrote:
> > hi, i don't know use the pg_dump instruccion and i
> need create a backup,
> > please someone has an example.
> > thanks
> > enzo
> >
>
---------------------------------------------------------
> >
> > Imagina tus vacaciones perfectas... y hazlas
> realidad. Juega en http://sorteos.ya.com
> > ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA.
> Navega y habla de forma ilimitada. Sin compromiso de
> permanencia. http://acceso.ya.com/ADSLllamadas/
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to
> choose an index scan if your
> > joining column's datatypes do not match
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_dump
@ 2005-06-15 15:48 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: operationsengineer1@yahoo.com
0 siblings, 0 replies; 7+ messages in thread
From: Christopher Kings-Lynne @ 2005-06-15 15:48 UTC (permalink / raw)
To: operationsengineer1@yahoo.com; +Cc: pgsql-php
Only problem is you need to stop PostgreSQL from running to do it...
operationsengineer1@yahoo.com wrote:
> i read that you can copy the contents of pgsql's data
> directory to create a backup, too. in order to
> restore the db, you clean out the data directory and
> then copy the "backed up" files back in to the data
> directory.
>
> i have no experience using this method, but i thought
> i'd mention it to see if anyone else has done this.
>
> --- Christopher Kings-Lynne
> <chriskl@familyhealth.com.au> wrote:
>
>
>>pg_dumpall <dbname> > backup.sql
>>
>>Chris
>>
>>enzo venegas palacios wrote:
>>
>>>hi, i don't know use the pg_dump instruccion and i
>>
>>need create a backup,
>>
>>>please someone has an example.
>>>thanks
>>>enzo
>>>
>>
> ---------------------------------------------------------
>
>>>Imagina tus vacaciones perfectas... y hazlas
>>
>>realidad. Juega en http://sorteos.ya.com
>>
>>>ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA.
>>
>>Navega y habla de forma ilimitada. Sin compromiso de
>>permanencia. http://acceso.ya.com/ADSLllamadas/
>>
>>>
>>>---------------------------(end of
>>
>>broadcast)---------------------------
>>
>>>TIP 9: the planner will ignore your desire to
>>
>>choose an index scan if your
>>
>>> joining column's datatypes do not match
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the
>>unregister command
>> (send "unregister YourEmailAddressHere" to
>>majordomo@postgresql.org)
>>
>
>
>
>
>
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone.
> http://mobile.yahoo.com/learn/mail
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_dump
@ 2005-06-15 16:06 Weber Matthias <weber@faps.uni-erlangen.de>
0 siblings, 0 replies; 7+ messages in thread
From: Weber Matthias @ 2005-06-15 16:06 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; operationsengineer1@yahoo.com; +Cc: pgsql-php
don't think so. here an extract from man pages
To dump a database:
$ pg_dump mydb > db.out
To reload this database:
$ psql -d database -f db.out
bye
matthias
-----Original Message-----
From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au]
Sent: Wed 6/15/2005 5:48 PM
To: operationsengineer1@yahoo.com
Cc: pgsql-php@postgresql.org
Subject: Re: [PHP] pg_dump
Only problem is you need to stop PostgreSQL from running to do it...
operationsengineer1@yahoo.com wrote:
> i read that you can copy the contents of pgsql's data
> directory to create a backup, too. in order to
> restore the db, you clean out the data directory and
> then copy the "backed up" files back in to the data
> directory.
>
> i have no experience using this method, but i thought
> i'd mention it to see if anyone else has done this.
>
> --- Christopher Kings-Lynne
> <chriskl@familyhealth.com.au> wrote:
>
>
>>pg_dumpall <dbname> > backup.sql
>>
>>Chris
>>
>>enzo venegas palacios wrote:
>>
>>>hi, i don't know use the pg_dump instruccion and i
>>
>>need create a backup,
>>
>>>please someone has an example.
>>>thanks
>>>enzo
>>>
>>
> ---------------------------------------------------------
>
>>>Imagina tus vacaciones perfectas... y hazlas
>>
>>realidad. Juega en http://sorteos.ya.com
>>
>>>ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA.
>>
>>Navega y habla de forma ilimitada. Sin compromiso de
>>permanencia. http://acceso.ya.com/ADSLllamadas/
>>
>>>
>>>---------------------------(end of
>>
>>broadcast)---------------------------
>>
>>>TIP 9: the planner will ignore your desire to
>>
>>choose an index scan if your
>>
>>> joining column's datatypes do not match
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the
>>unregister command
>> (send "unregister YourEmailAddressHere" to
>>majordomo@postgresql.org)
>>
>
>
>
>
>
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone.
> http://mobile.yahoo.com/learn/mail
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
^ permalink raw reply [nested|flat] 7+ messages in thread
* pg_dump
@ 2005-09-12 16:56 enzo venegas palacios <enzovenegas@mixmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: enzo venegas palacios @ 2005-09-12 16:56 UTC (permalink / raw)
To: pgsql-php
Hello,
I have postgresql, apache, win2K and php in a intranet
I am trying to create a backup with pg_dump
ex:
pg_dump -i -U nombre_de_usuario -Fc -b -v -f "C:\Archivos de
programa\PostgreSQL\8.0\backup.backup" nombre_db
And I have to execute it from php with exec from the web page
ex:
exec ("C:\Archivos de programa\PostgreSQL\8.0.0-rc1\bin>pg_dump -i -U
nombre_de_usuario -Fc -b -v -f "C:\Archivos de
programa\PostgreSQL\8.0\backup.backup" nombre_db");
My problem is that this code asks for password me and on having executed
the command exec it cannot be deposited
ex:
C:\Archivos de programa\PostgreSQL\8.0.0-rc1\bin>pg_dump -i -U
nombre_de_usuario -Fc -b -v -f "C:\Archivos de
programa\PostgreSQL\8.0\backup.backup" nombre_db
C:\pass:_
There exists some form of which he(she) does not ask for the key me?
Treat creating users without key, but it(he,she) gives the same result
enzo
---------------------------------------------------------
Vuelve el pleno al 15. Juega a la quiniela y hazte millonario en http://sorteos.ya.com
Ya.com ADSL 2MB + Llamadas 24 horas: desde 26,95 /mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/2mb
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_dump
@ 2005-10-04 22:22 Jim C. Nasby <jnasby@pervasive.com>
parent: enzo venegas palacios <enzovenegas@mixmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Jim C. Nasby @ 2005-10-04 22:22 UTC (permalink / raw)
To: enzo venegas palacios <enzovenegas@mixmail.com>; +Cc: pgsql-php
You could setup pg_hba.conf to allow a backup user to connect to the
database locally via trust authentication. I think you could also use a
.pgpass file.
On Mon, Sep 12, 2005 at 11:56:37AM -0500, enzo venegas palacios wrote:
>
> Hello,
>
> I have postgresql, apache, win2K and php in a intranet
> I am trying to create a backup with pg_dump
>
> ex:
> pg_dump -i -U nombre_de_usuario -Fc -b -v -f "C:\Archivos de
> programa\PostgreSQL\8.0\backup.backup" nombre_db
>
> And I have to execute it from php with exec from the web page
>
> ex:
> exec ("C:\Archivos de programa\PostgreSQL\8.0.0-rc1\bin>pg_dump -i -U
> nombre_de_usuario -Fc -b -v -f "C:\Archivos de
> programa\PostgreSQL\8.0\backup.backup" nombre_db");
>
> My problem is that this code asks for password me and on having executed
> the command exec it cannot be deposited
>
> ex:
> C:\Archivos de programa\PostgreSQL\8.0.0-rc1\bin>pg_dump -i -U
> nombre_de_usuario -Fc -b -v -f "C:\Archivos de
> programa\PostgreSQL\8.0\backup.backup" nombre_db
> C:\pass:_
>
>
> There exists some form of which he(she) does not ask for the key me?
>
> Treat creating users without key, but it(he,she) gives the same result
> enzo
> ---------------------------------------------------------
>
>
> Vuelve el pleno al 15. Juega a la quiniela y hazte millonario en http://sorteos.ya.com
> Ya.com ADSL 2MB + Llamadas 24 horas: desde 26,95 ?/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/2mb
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-10-04 22:22 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-14 22:34 pg_dump enzo venegas palacios <enzovenegas@mixmail.com>
2005-06-15 01:24 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-06-15 15:27 ` operationsengineer1@yahoo.com
2005-06-15 15:48 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-06-15 16:06 Re: pg_dump Weber Matthias <weber@faps.uni-erlangen.de>
2005-09-12 16:56 pg_dump enzo venegas palacios <enzovenegas@mixmail.com>
2005-10-04 22:22 ` Jim C. Nasby <jnasby@pervasive.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