I will create several databases on PostGreSQL. All the databases have the
same structure: same number of table/index.
I have two choices:
1. For each database, I create a new tablespace and create a new database in
the tablespace.
2. I only create one tablespace. Create all the databases on the sam
On Thu, Jun 25, 2009 at 12:10 PM, Bill Moran wrote:
> In response to Jack W :
>
> > On Thu, Jun 25, 2009 at 11:37 AM, Bill Moran >wrote:
> >
> > > In response to Jack W :
> > >
> > > > I will create several databases on PostGreSQL. All the datab
The default user mode of PostgreSQL is single user mode. How to enable
multi-users mode?
Thanks.
Jack
Assume that I have the following database:
Database:mydb
Schema: mydb_schema
Tables:mydb_table1
mydb_table2
mydb_table3
I create a role: Create Role dbuser LOGIN;
mydb=# grant all privileges on mydb_schema.mydb_table1 to dbuser;
mydb=# g
On Thu, Mar 12, 2009 at 3:45 PM, John R Pierce wrote:
> Jack W wrote:
>
>>
>> I also find that if I only grant privileges on database to dbuser as
>> below, without granting privileges on Schema and table to dbuser, dbuser
>> still can not do SELECT on the tables.
I installed PostgreSql on Window2003 server under an administrator account.
I can start postgresql from Windows Service.
But when run the following command, it fails:
C:\Program Files\PostgreSQL\8.3\bin>pg_ctl start -D "C:\Program
Files\PostgreSQL\8.3\data"
server starting
C:\Program Files\Postgr
I set up a failover system with one primary server and one standby server.
In the standby server's log, I saw the lines like below:
Command for restore: copy "E:\archive\0001004C"
"pg_xlog\RECOVERYXLOG"
The above line means that: the transaction log file 000100
