Gabriele Bartolini ha scritto:
Ciao Michele,
Ciao ;)
both server (master and standby) need a common directory where
read
and write the wal files?
Not necessarily. You can use for instance scp to ship the WAL file
from the master to the standby using the network.
Thanks for the
Fujii Masao ha scritto:
On Fri, Oct 1, 2010 at 4:02 PM, Michele Petrazzo - Unipex
michele.petra...@unipex.it wrote:
- why in my tests, _whitout_ common direcotory, master and slave
keep in sync also if I shutdown slave, add (in my last tests)
something about 100k record (although little ones
Hi list,
I'm trying the new features into a test environment for see how all
works and I'm finding first problems with setup.
After reading the various Streaming_Replication, Warm_Standby and
What's_new_in_PostgreSQL_9.0 on the wiki, one first question born: both
server (master and standby) need
Luís de Sousa ha scritto:
Hello everyone,
I need to replace all occurrences of a certain character in a string.
For that I'm using regexp_replace, but so far I only managed to
replace the first character, here's an example:
SELECT regexp_replace('xaxx', 'x', 'e');
regexp_replace
Hi list,
now I just uncovered a strange behavior from my point of view: I have a
table with a trigger associated with its insert. If I rename that table,
the trigger follow its parent.
Are this a wanted and the normal behavior? Are there somewhere a
documentation about?
Thanks,
Michele
--
Hi all,
I had a big problem that made me crazy... I want to simple backup some
tables from a my db and restore them to another.
My db:
table_two(
id serial PRIMARY KEY,
...
)
table_one (
id serial PRIMARY KEY,
real_name text NOT NULL,
username text NOT NULL,
id_table_two
Hi all,
I had a big problem that made me crazy... I want to simple backup some
tables from a my db and restore them to another.
My db:
table_two(
id serial PRIMARY KEY,
...
)
table_one (
id serial PRIMARY KEY,
real_name text NOT NULL,
username text NOT NULL,
id_table_two
Scott Marlowe wrote:
I think that this is a strange question, but: I need to revoke the
select permission on a table, but I also need to leave, with a function,
a user do a query on column.
A real case can be that a user test cannot have the permissions for do
a select * from articles, but for
I think that this is a strange question, but: I need to revoke the
select permission on a table, but I also need to leave, with a function,
a user do a query on column.
A real case can be that a user test cannot have the permissions for do
a select * from articles, but for do a select