can the server error messages language be changed somehow without
remaking it from the sources? the software catches english error
messages for now & handles them well, but the freshly installed from rpm
postgres returns error messages in russian & this causes software errors.
--
> How might we (1) locate which pg_hba.conf file postgres uses on
cygwin and (2)
> where pg is storing the data. I looked into the environment but
couldn't
> find anything there.
1) try to copy pg_hba.conf.sample or pg_hba.conf (wherever it is @ your
host) to $PGHOME/data & edit it then.
2) dat
edit *pg_hba.conf *
# Allow any user on the local system to connect to any
# database under any username, but only via an IP connection:
host all 127.0.0.1 255.255.255.255trust
# The same, over Unix-socket connections:
local
How can i dump a password-protected database using perl (DBI or pg) or C
(using libpq)? I can't pass the password to pg_dump utility (I was
trying to pass it via tty also) when running system() from perl.
---(end of broadcast)---
TIP 4: Don't 'ki
How can i dump a password-protected database using perl (DBI or pg) or C
(using libpq)? I can't pass the password to pg_dump utility (I was
trying to pass it via tty also) when running system() from perl.
Isn't example below something like what you are trying to do:
8<
#include
#incl
How can i dump a password-protected database using perl (DBI or pg) or C
(using libpq)? I can't pass the password to pg_dump utility (I was
trying to pass it via tty also) when running system() from perl.
Isn't example below something like what you are trying to do:
8<
#include
#incl
every concurrent cgi script uses its own postgres connection in your
case. you're going to run into more serious problems (e.g. empty pages
for no reason) because of lack of possible postgres connections. so,
1) try mod_perl to speed up your perl scripts
2) think about writing a server which woul
Chris Miles wrote:
On Thu, Nov 14, 2002 at 10:47:20AM +0300, dima wrote:
2) think about writing a server which would provide cgi scripts with
cached connections; you can $handle->prepare(...) the most common
queries as well.
This seems like a common requirement. Are there any such to
ris Miles wrote:
On Thu, Nov 14, 2002 at 10:47:20AM +0300, dima wrote:
2) think about writing a server which would provide cgi scripts with
cached connections; you can $handle->prepare(...) the most common
queries as well.
This seems like a common requirement. Are there any such tools which
c
Am I missing something? There seems to be no way to dump all databases
and then restore them (as you'd have to do on a version change) if the
databases contain blobs.
pg_dump supports dumping of blobs with the -b -Ft switch, but using
pg_dumpall with those switches doesn't seem to work. And
On first glance at dima's script it does not seem to deal with blobs,
although could easily me made to do so.
Also it does not address automated reloading. In light of the fact that
blobs must be output by -Ft or -Fc in pg_dump, which are tar and custom
respectively, the result of an entire db se
On first glance at dima's script it does not seem to deal with blobs,
although could easily me made to do so.
I think that would be a very good addition to the PostgreSQL toolkit.
FWIW, I do not use blobs and consequently do not think of them when
backups are required.
I'll be working on it so
Hello Paul:
What user are you using. Remember, you have a brand new install and
haven't created any users yet, except for the superuser(postgres). Try
connecting as the postgres(superuser).
btw, are you trying to start postmaster as root? it seems that there's a
bug in postgresql: it says it st
I am looking at using postgresql for a database to support some dynamic web
site work I am doing.
Can you please let me know if it is at all possible to obtain information
about the number of users connected to a given database and their associated
details i.e. connection time, user name etc...
I am trying to automate my backups using pg_dump. However, I am not able to
pass the password to the command. Has anybody sucessfully done automated
backup thru scripts?
export PGPASSWORD=password && pg_dump ... && export PGPASSWORD=""
---(end of broadcast)---
15 matches
Mail list logo
