[GENERAL] backup database by cloning itself

t to be able to copy a database even if the database is used by someone. Can I use CREATE DATABASE my_backup_database TEMPLATE current_database? Is there a better way to get what I need? Thanks, Filippo ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] backup database by cloning itself

On 13 Feb, 14:54, "filippo" <[EMAIL PROTECTED]> wrote: > My target is to have the backup operation not affecting the users, so > I want to be able to copy a database even if the database is used by > someone. I could use pg_dump/pg_restore. pg_dump doesn't ha

Re: [GENERAL] backup database by cloning itself

On 14 Feb, 08:33, [EMAIL PROTECTED] (Ron Johnson) wrote: > -BEGIN PGP SIGNED MESSAGE- > There's almost definitely a better way to do what you want to do. > > What benefit are you trying to obtain by creating 720 almost > identical databases per month? I only need the last 24, overwriting e

[GENERAL] passing passords to pgsql/pg_create/pg_dump programmatically

passowrd programmatically or how can I interact with these to give the passwords by a graphic box? Thanks and best refards, Filippo ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs

[GENERAL] shell script to SQL statement: `pg_dump | psql -U`

I have a perl program that I use (also) to copy a database to a perfect clone having a different name. To perform the operation I execute from perl the following shell pipe pg_dump -U postgres -h db_server database_name | psql -U postgres -h db_server database_name_backup I'd like to perform the

Re: [GENERAL] shell script to SQL statement: `pg_dump | psql -U`

On 20 Mar, 16:47, [EMAIL PROTECTED] (Tom Lane) wrote: > "filippo" <[EMAIL PROTECTED]> writes: > > The problem with the current implementation is that sometime pd_dump > > and psql ask for password but I want to create the database copy > > without any user typ

Re: [GENERAL] shell script to SQL statement: `pg_dump | psql -U`

On 23 Mar, 19:32, [EMAIL PROTECTED] wrote: thanks Margaret, I didn't know window scheduler so far. By the way I have choosen to do all management stuff on database via command line programs, providing passowd file for administrator user. Thanks Filippo ---(e

[GENERAL] load the whole database into RAM

your needs and load everithing on it. Is it possible and, of course, effective? Just taking a look to some tuning document I didn't find a direct answer (I'm not a smart guy) Thanks, Filippo ---(end of broadcast)--- TIP 6: explain

[GENERAL] stored queries and quoted strings

execute($tempCity); my $result = $sthCity->fetchall_arrayref; bu I'm a little bit worried to use a a WHERE statement without quoting the search pattern (input by user). Is it a problem or not? Thanks, Filippo ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] perl DBI: problems searching text strings with ' symbol (es d'ambrose)

On 7 Apr, 01:47, "filippo" <[EMAIL PROTECTED]> wrote: > On 7 Apr, 01:26, "filippo" <[EMAIL PROTECTED]> wrote: just to clarify: I can insert text into database. My problem are the SELECT query like this WHERE name LIKE $name $name = $dbh->quote(qq/ d'a

[GENERAL] perl DBI: problems searching text strings with ' symbol (es d'ambrose)

s with ' character, how can I do? Thanks, Filippo ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] perl DBI: problems searching text strings with ' symbol (es d'ambrose)

On 7 Apr, 01:26, "filippo" <[EMAIL PROTECTED]> wrote: > hello, > > if I try to insert text like > > $dbh->quote(qq/d'ambrose/); > > when I try to search names with character lile ', I get this error I forgot to say that I need LIKE and

Re: [GENERAL] perl DBI: problems searching text strings with ' symbol (es d'ambrose)

On 7 Apr, 10:13, "filippo" <[EMAIL PROTECTED]> wrote: solved, it is a DBD::PgPP bug. I changed to DBD::Pg, now it works fine. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] change database encoding without corrupting data (latin9 to utf8)

: $dbh->do(qq/SET client_encoding to 'UTF8'/); To avoid such kind of workaround I'd like to convert the whole database from LATIN9 to UTF8, how can I do it without corrupting the data? Thanks, Filippo ---(end of broadcast)-