Hello,
i need make with postgre something as this:
i have two servers S1 and S2, connection is quit good, but sometimes once
or twice per month there is short disconnection, longer discoonection 2x per
year (1-2+ hours)
on both are running updates
i need have same data in time, but i never upda
Did you try Slony with PostgreSQL?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/4/07, anorganic anorganic <[EMAIL PROTECTED]> wrote:
Hello,
i need make with postgre something as this:
i have two servers S1 and S2, connection is quit good, but sometimes once
or twice pe
What is your current logging level that is been set in the conf file?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/4/07, Ming <[EMAIL PROTECTED]> wrote:
Hi, I recently upgraded from 8.1.4 to 8.2.0, everything was fine
except that I suspect that the autovacuum was not runn
Hi,
did you check the manual about 'High Availability and Load Balancing"?
http://www.postgresql.org/docs/8.2/static/high-availability.html
Regards
Markus
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi,
anorganic anorganic wrote:
>> did you check the manual about 'High Availability and Load
>> Balancing"?
>> http://www.postgresql.org/docs/8.2/static/high-availability.html
>
yes but this was really short i think.
Interesting... where exactly is it to short for you? What else would you
exp
On Thu, 2007-01-04 at 11:30 +0700, Ming wrote:
> Hi, I recently upgraded from 8.1.4 to 8.2.0, everything was fine
> except that I suspect that the autovacuum was not running. In
> pgAdmin's server properties, the "Autovacuum" property shows
> "runnning", but I couldn't find any log entry for the au
Try looking at pg_stat_all_tables at these columns:
last_vacuum
last_autovacuum
last_analyze
last_autoanalyze
Kind regards.
On 1/4/07, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Thu, 2007-01-04 at 11:30 +0700, Ming wrote:
> Hi, I recently upgraded from 8.1.4 to 8.2.0, everything was fine
> exce
Hi folks,
i must analyze a customer's database offline. Can i import the databse
of the customer into our PostgreSQL environment ?
What must the customer send us ?
Whats the doings for us to open it in our envioronment ?
Josef
---(end of broadcast)--
Hi,
[ please keep CCing to the list (reply all), as this certainly isn't a
personal discussion and could help others. ]
anorganic anorganic wrote:
Hello,
"I don't quite follow what you mean here. I assume you mean rows, not
columns. Then probably you mean something like what we call data
par
Use pg_dump/pg_dump utility to take the db dump and then you can restore it
using psql or pg_restore at your end.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/4/07, Josef Springer <[EMAIL PROTECTED]> wrote:
Hi folks,
i must analyze a customer's database offline. Can
Hello,
We have a windows-based server that uses postgres (8.1) as the db. We use a
'silent install' to install postgres as a windows service. Our server is then
installed as a service with a dependency on postgres.
As seen in other posts, to ensure that postgres starts up before the server
sta
Hello Pete,
There is certainly a Windows command you can run that will alter the
command used to start a service - it's "sc" (which can also be used to
start/stop a service programmatically.)
The command syntax to modify the EXE path is:
sc config binpath= ""
(eg.)
sc config "PostgreSQL Dat
Is there any way to make a dump from a query?
select field1,field2 from table
Does it exist a shell command like pg_dump --QUERY myquery -f myfile?
Belated, but it looks this is another way (equivalent to Andy Shellam's)
cat >> query.txt
select field1,field2 from table
^D
1. psql $database
I already found the answer, sorry... my mistake for not checking the
8.2.0 release note first. It turns out that such behaviour is expected
in 8.2.0, i.e. autovacuum process no longer add an entry to the server
log.
http://www.postgresql.org/docs/current/static/release-8-2.html
But then, another
14 matches
Mail list logo