* Gnanakumar wrote:
We're using PostgreSQL v8.2.3.
How do I get the schema name in which TEMPORARY table is created using
CREATE TEMP TABLE mytable syntax?
SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema();
I don't have an 8.2.3 lying around, but git says that function
Hi,
We're using PostgreSQL v8.2.3. Ours is a web-based application, language is
Java and we're using pgpool-II v 2.0.1 purely for connection pooling (we
don't use other features of pgpool like Replication, Load Balancing, etc.).
I've an implementation-specific question related to creating of
hi guys
I am in the process of converting my network to IPv6 only (well, as
much as possible).
Since our own network has fully functional IPv6 connectivity, I should
be able to move all services that are used internally only, to IPv6
only.
Postgres is one of those services.
I could not find
El mié, 09-03-2011 a las 13:58 +0100, Dyonisius Visser escribió:
hi guys
I am in the process of converting my network to IPv6 only (well, as
much as possible).
Since our own network has fully functional IPv6 connectivity, I should
be able to move all services that are used internally
We have postgreSQL 8.3.8 installed on a windows 8 server (64 bit).
We want to be able to run a nightly backup using the pg_dump command.
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
It still asks for a password.
1. Is this a 64bit issue? If the
On Mar 9, 2011, at 7:28 PM, Sandy Test wrote:
We have postgreSQL 8.3.8 installed on a windows 8 server (64 bit).
We want to be able to run a nightly backup using the pg_dump command.
Unfortunately, even with the pg_hba.conf fix of adding host postgres … trust,
It still asks for a
On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar gna...@zoniac.com wrote:
So, now we've decided to either DROP TABLE pg_temp_xx.FOO or DROP SCHEMA
pg_temp_xx explicitly just before closing the connection (after step 3 and
before step 4), so that it'll not be visible for the next database
connection
On Wed, Mar 09, 2011 at 03:58:20PM +0200, Sandy Test wrote:
We want to be able to run a nightly backup using the pg_dump command.
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
It still asks for a password.
pg_hba sometimes surprises people because of
On Wednesday, March 09, 2011 5:58:20 am Sandy Test wrote:
2. Is there a way of running a dos script that would run the pg_dump
providing a password when prompted?
Using .pgpass
http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html
Thanks
Sandy Test
--
Adrian
Scott Marlowe scott.marl...@gmail.com writes:
On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar gna...@zoniac.com wrote:
So, now we've decided to either DROP TABLE pg_temp_xx.FOO or DROP SCHEMA
pg_temp_xx explicitly just before closing the connection (after step 3 and
before step 4), so that it'll
Andrew Sullivan a...@crankycanuck.ca writes:
On Wed, Mar 09, 2011 at 03:58:20PM +0200, Sandy Test wrote:
We want to be able to run a nightly backup using the pg_dump command.
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
It still asks for a password.
On Wed, Mar 09, 2011 at 10:31:56AM -0500, Tom Lane wrote:
Andrew Sullivan a...@crankycanuck.ca writes:
On Wed, Mar 09, 2011 at 03:58:20PM +0200, Sandy Test wrote:
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
If it is asking for a password, and password
I had this issue back in pg 7.x, and it was resolved by using -a in vacuumdb.
I'm having it again in v8.4.4.
So, my pg_clog directory contains files going back to Jul 13 of 2010.
Every Saturday, I run:
vacuumdb -a -v -F
I _thought_ that was supposed to clear those out. Am I wrong?
Scott Whitney sc...@journyx.com wrote:
my pg_clog directory contains files going back to Jul 13 of 2010.
Every Saturday, I run:
vacuumdb -a -v -F
I _thought_ that was supposed to clear those out. Am I wrong?
SELECT datname, datfrozenxid FROM pg_database;
to see which database
Hi All -
Please let me know if this is possible to do in postgres.
I am creating a read only user, which has limited access to db objects,
primarily views. Even though this user can't query data from other db
objects it can view the system catalog using pg* views and tables,
thereby exposing
Hi All,
We are using Tsung to load and stress test postgresql. Tsung runs such a way
that it need the application to use a port that Tsung listens to as a proxy.
So in our case we need psql to use Tsung as a proxy to ulimately connect to
postgresql. Is there a way for psql to use a particular
On Mon, Mar 7, 2011 at 10:00 AM, H S aras_h1...@yahoo.com wrote:
We would like to implement Oracle Label Security or Row level security or
associated concepts mechanism on PostgreSQL.
for pg = 9.0 you can try: http://wiki.postgresql.org/wiki/SEPostgreSQL
part of this is now part of pg 9.1
17 matches
Mail list logo
