Tagged Questions
1
vote
2answers
55 views
Limiting read access in postgres to few rows
We have a requirement where we want to limit the maximum no. of rows that a select query can return when its done using a particular login. So basically we would like to append a limit clause to any ...
2
votes
0answers
40 views
How to make PostgreSQL default_tablespace work properly?
My question is, "Why isn't database 'screwy' created in tablespace 'screwy'?
I made the following script, with it's output following, to show the problem I am having :
#!/bin/bash
#
export ...
2
votes
0answers
304 views
How to properly configure pgBouncer transaction level pooling?
What is a good way to determine the number of available transaction connections when using pgBouncer to pool database connections? Also, how should I determine the number of max_connections and ...
0
votes
0answers
132 views
Can't connect to local Postgres databases
After trying to install Postgres using Postgres.app and EnterpriseDB, I decided to re-install it using Homebrew (As I got some problems connecting to database).
PYTHON=/usr/local/bin/python brew ...
0
votes
0answers
32 views
PostgresPlus advanced server replication testing issue
I made the replication on my Windows Server 2003 system as master DB and another XP system for slave DB. I just made the configuration, but I don't know how to check the replication of database.
I ...
