Hi dan
IF possible i suggest to put a restriction from where your users come with
netwotk and mask.
I think that your solution is to complicate and suggest that all database is
owned by postgres with strong password and give your user full grant for a
single database.
so you haven't to manage a
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
i am install psql
and createuser db,
how i can see the user howmany i can creaded??
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
i had postgresql installed with linux.
now iam unable to work with postgresql.i couls create a database, but when i issue
pg_ctl -D database location command, it is giving the following error:
\can\'t lock the file /tmp/.s.PGSQL.5432.lock:permission denied.\
when issue any command, it is giving
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.
My client would like to test using a ram drive to hold some of our
postgre files. Does anybody have any suggestions for how to go about
doing this? Details are below:
http://www.3dretreat.com/reviews/rocketdrive/
This is a review that explains the benefits of a ram drive: it's a pci
card
On 22 Nov 2002 at 19:07, dima wrote:
i wrote a script in perl which dumps all the DBs but template*
i can mail it to you if you wish
Why not post it to the list? That way it's available for everyone.
I'm guessing it'll be less than 2K or so...
--
Dan Langille : http://www.langille.org/
In bash, I use:
== script fragment ==
~!/bin/bash
$BackupDir=whereever
$LogFile=whichever
for db_name in $(/usr/local/pgsql/bin/psql -U postgres -d template1 -n -t -c
select datname from pg_database where datistemplate='f';);
do
/usr/local/pgsql/bin/pg_dump
Dan,
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
On 22 Nov 2002 at 14:41, Colin Stearman wrote:
Dan,
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
Hi All,
Don't know if anyone else has had this problem (I'm hoping someone else has
had this problem:)
If I create a second or third schema (PG7.3) in PgAdminII and then create a
view or table in the new schema and attempt to view the data the following
message results:
22/11/2002 07:51:05 -
okay, argh, after messing around with /etc/security/limits.conf, it would
have been nice to know that limits.conf doesn't change the default ulimit
rather the limits of user ulimit changes! mean to say, pam_limits.so and
limits.conf do not change the default ulimit, just the bounds, so then the
http://ems-hitech.com/pgsqlutils/download.phtml
http://gborg.postgresql.org/browse.php?81
C.
Benjamin Stewart wrote, On 11/21/2002 11:40 PM:
Greetings,
After a few suggestions for a good DB managmen application for linux. I
have found a few and they are a little average. Appears that there are
Greetings,
After a few suggestions for a good DB managmen application for linux. I
have found a few and they are a little average. Appears that there are
some good applicaitons in windows, but not linux.
Thanks
Ben
---(end of broadcast)---
TIP
It would be great if somebody could review our
pg_hha.conf file below to see if it does what we want it to, no more and no
less.
The goals for our pg_hba.conf file
are:
1) In an emergency allow somebody with
operatating
system root privs access to all
the databases with full privs.
2)
Hi guys
I had just recreate database that deleted some
useful data in one of teh table. There's no backup dump badly. But as i know
there a transaction log taht will log everything from beginning, anyone know how
to do a rollback or roll forward?
I ran into this problem when running
almost any command using psql, createdb or even trying to goto the shell using
\!
The problem is that /bin/sh points
to /bin/bash and my bash version is:
$ bash -version
GNU bash, version 1.14.7(1)
Here are the other errors:
$ createdb foo
I ran into this problem when running almost any command
using psql, createdb or even trying to goto the shell using \!
The problem is that /bin/sh points to /bin/bash and my bash
version is:
$ bash -version
GNU bash, version 1.14.7(1)
Here are the other errors:
$ createdb foo
raid 0 (striping) spreads the load over multiple spindels, the same way raid 5
does. but raid 5 always needs to calculate parity and write that to it's
parity drive.
RPM isn't that critical, a lot depends on the machine, the processor and the
memory (and the spped with which the processor can
On Mon, 18 Nov 2002, Chris Schneider wrote:
Hi Chris,
PostgreSQL has something very similar to what Oracle does, although still
different:
pg_databases - Stores general information for each database.
pg_shadow - Stores information on the users, such as access levels,
passwords,
On Thursday 21 November 2002 20:05, Tim Lynch wrote:
increase their ulimits - call me old fasioned... what's next, regular user
negative renice?!? anyways...
Actually yes.
but, uh, what am i going to do with a core file? i would need a
non-stripped postgres binary first, right?
If you
Hey folks:
I am mounting the learning curve from MySQL to postgreSQL. It seemed so
straight forward before. On my Win98 box, everything was clearly named as
I had designated in the c:/mysql/data directory. On the Debian server, the
/var/lib/mysql directory is similarly and intuitively laid
22 matches
Mail list logo