* 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 tem
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 anywh
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 serve
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 pa
On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar 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 request. My
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 becaus
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
>
-
Scott Marlowe writes:
> On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar 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 data
Andrew Sullivan 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.
> pg_hba s
On Wed, Mar 09, 2011 at 10:31:56AM -0500, Tom Lane wrote:
> Andrew Sullivan 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 authentica
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 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 is caus
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 por
On Mon, Mar 7, 2011 at 10:00 AM, H S 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 (not yet released)
17 matches
Mail list logo