Greetings all-
Running postgresql under debian, my standard apt-get upgrade upgraded me
from 8.3 to 8.4. As a result, I no longer have access to the databases
that were created under 8.3. Typically I would use pg_upgradecluster to
fix this problem; however, the upgrade also removed 8.3, and so
In your postgresql.conf file (on my system this is /etc/postgresql.conf -
don't know how standard that is) insert the following line:
debug_print_query = on
then restart the postmaster (again, on my system: /etc/init.d/postgresql
restart) and you'll be on your way. It ends up in the general
postg
Use your postgresql.conf file to enable logged connections:
log_connections = on
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perr
, Bruno Wolff III wrote:
> On Fri, Jan 17, 2003 at 08:57:14 -0500,
> Andrew Perrin <[EMAIL PROTECTED]> wrote:
> > I'd suggest something similar to, but slightly different from, what others
> > have:
> >
> > SELECT DISTINCT email FROM (SELECT email FRO
I'd suggest something similar to, but slightly different from, what others
have:
SELECT DISTINCT email FROM (SELECT email FROM table_1 UNION SELECT
email FROM table_2) AS combined;
that way you avoid duplicates across tables.
--
often
ap
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Wed, 30 Oct 2002, Tom Lane wrote:
> Andrew Perrin <[EMAIL PROTECTED]> writes
Folks,
I just made a mistake that could be quite costly: I did this:
update writer_survey set partid='W41308' where survid in (select survid
from participants where partid='W41291' limit 1);
when I should have done this:
update writer_survey set partid='W41308' where survid in (select survid
fr
You could write a perl script; you'd need to install perl on the windows
box and then just wrap an execute() around each command entered. Not
exactly elegant but functional.
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assist
ill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Mon, 3 Jun 2002, Naomi Walker wrote:
> At 12:18 PM 6/3/2002 , Andrew Perrin wrote:
> >What's the reason for doing this? Just use separate databases -- if
> >necessary, with different users given permissions on each -- in the same
What's the reason for doing this? Just use separate databases -- if
necessary, with different users given permissions on each -- in the same
postmaster instance.
ap
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Prof
Are you using the {AutoCommit => 0} argument to DBI->connect()? If not,
do so, and then add a $dbh->commit; line when you're done with the
inserts. Should help a lot.
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Pr
Greetings.
Running 7.0.3 under Debian 2.2, I'd like postmaster to start on boot with
the -i option. I've got it working with just the defaults, using
start-stop-daemon, but for some reason it ignores the section after the
--, which the start-stop-daemon documentation claims will be passed as
argu
http://www.sunfreeware.com/faq.html#q0 gives details on getting gzip onto
your system. There are also copious instructions on how to install
everything.
-
Andrew J. Perrin - [EMAIL PROTECTED] - NT/Unix Admin/Support
Department of
I figured this out recently with the help of the list - you want either
nextval() or currval(). In my case, I used currval(). Basically:
SELECT currval('table_field_seq');
will return the most recently assigned value to the field *by the current
backend* which means:
- There's no danger of a
Folks-
I'm a bit concerned about postgres security. Here's the situation. I've
got the following in pg_hba.conf:
localall trust sameuser
localall trust pgwww
host all 127.0.0.1 2
Check out the GRANT command in postgres; you'll want to do something like:
CREATE USER nobody WITH PASSWORD ;
GRANT SELECT ON , TO nobody;
However, I like to use suExec under apache to have things run by a
different user; that offers somewhat more security. I have scripts that
need, for exampl
Greetings.
I just downloaded the precompiled NT DBD::Pg perl package. It works great
(actually, amazingly quickly - like at least 10x the speed of ODBC), but
security seems like a serious problem. The only way the connection works
is if I set pg_hba.conf to all trust - any of the authentication
17 matches
Mail list logo
