Greetings,
Is there a way to build just the binaries? My users connect from
another machine. The libraries are not in the same place on the
machine. I don't want to add the load library path to their profiles
because there are two instances of postgres they need to get to and
the
Tom Lane wrote:
If there's some identifiable bit of the documentation that confused you
about this, please point it out so we can improve it.
... because, apparently, lots of people are bitten by the same
misunderstanding.
--
Alvaro Herrera
Hello,
I'm putting together a web app that uses PostGRES as a backend and I'm
looking for comments on backup strategy.
The entire web app, (Tomcat and PostGRES), will be run in a virtual
machine. I was thinking about quiescing the DB, then copying the files that
make up the virtual machine to
Well, there are a lot of unanswered questions in your post.
What VM technology are you using? Does it support clustering or some such?
Do you need to backup the entire VM, or just the PG data?
Generally speaking, if the machine itself (installed OS and programs, etc)
are not changing, what I
Richard Sickler richard.sick...@avagotech.com writes:
The entire web app, (Tomcat and PostGRES), will be run in a virtual
machine. I was thinking about quiescing the DB, then copying the files that
make up the virtual machine to some network attached backup store. This
will be done once a
Greetings:
I'm a PHP programmer and I've had some troubles on using PostgreSQL as Database
Manager. The point is that I want to know if there is anyway one can create a
table without inserting inside the public schema. What would be desirable is
that my tables could be outside any schema.
Hello,
Alvaro Herrera wrote:
Tom Lane wrote:
If there's some identifiable bit of the documentation that confused you
about this, please point it out so we can improve it.
... because, apparently, lots of people are bitten by the same
misunderstanding.
Maybe it's not the documentation
Félix Sánchez Rodríguez wrote:
Greetings:
I'm a PHP programmer and I've had some troubles on using PostgreSQL as
Database Manager. The point is that I want to know if there is anyway
one can create a table without inserting inside the public schema.
What would be desirable is that my tables
On Tue, Mar 31, 2009 at 1:20 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Tue, Mar 31, 2009 at 10:04 AM, Rafael Domiciano
rafael.domici...@gmail.com wrote:
Hello People,
I have some doubts about Vacuum Full. There We go:
1) The Only thing that Vacuum Full (Only Full, not Analyze)
Hi Rafael,
On Wed, Apr 01, 2009 at 06:51:00PM -0300, Rafael Domiciano wrote:
I have some doubts about Vacuum Full. There We go:
1) The Only thing that Vacuum Full (Only Full, not Analyze) is to clean
dead space on the disc, and reorganize the relation at the physical
level?
If it's
I made a mistake and sent my post personally to Chander Ganesan, here it is:
Have you used PHP with PostgreSQL?? (Especifically the Doctrine
Framework??). Because my question arises from the fact that I've had
problems when rying to use Doctrine with a PostgreSQL database and I thought
that
Félix Sánchez Rodríguez wrote:
Have you used PHP with PostgreSQL??
Yep - daily. :)
(Especifically the Doctrine
Framework??).
Not familiar with that one. I don't have a framework (well, I do, but I
wrote it), but I use PDO (PHP Data Objects) as the interface.
Because my question arises
Félix Sánchez Rodríguez fesa...@ciego.cult.cu wrote:
I've figured out that it's not the same to use 'SELECT NICK FROM
USUARIOS' vs. 'SELECT Nick from Usuarios'
In PostgreSQL the first is interpreted the same as:
SELECT nick from usuarios;
Note that this is different from the ANSI ISO
On Wed, Apr 1, 2009 at 4:10 PM, Tino Schwarze postgre...@tisc.de wrote:
Hi Rafael,
On Wed, Apr 01, 2009 at 06:51:00PM -0300, Rafael Domiciano wrote:
I have some doubts about Vacuum Full. There We go:
1) The Only thing that Vacuum Full (Only Full, not Analyze) is to clean
dead space on
Scott Marlowe scott.marl...@gmail.com writes:
Nowadays, with many many new users, and no historical context, they do
just take it for a better kind of vacuum when in fact it is really
like reindex to indexes. I'd vote for rebuild [table]; as the new way
to spell vacuum full;
Well, no,
On Wed, Apr 01, 2009 at 08:09:31PM -0400, Tom Lane wrote:
Nowadays, with many many new users, and no historical context, they do
just take it for a better kind of vacuum when in fact it is really
like reindex to indexes. I'd vote for rebuild [table]; as the new way
to spell vacuum full;
Tino Schwarze postgre...@tisc.de writes:
Maybe we should remove the code and make
VACUUM FULL do the table-rewrite thing.
What do you mean with the table-rewrite thing, exactly?
Like CLUSTER, except not bothering to sort the rows: just seqscan the
table, enter all live tuples into a new
Thanks to all for your answers, I converted my tables and fields to
lowercase and now everything works perfectly.
- Original Message -
From: Kevin Grittner kevin.gritt...@wicourts.gov
To: Félix Sánchez Rodríguez fesa...@ciego.cult.cu;
pgsql-admin@postgresql.org
Sent: Thursday, April
18 matches
Mail list logo