I had to change the file
postgresql.conf (section FILE LOCATIONS ->
data_directory)because I need to point to another location.
But when I reboot the system, it indicates fail (red color) on the startup of
postgresql service.
But then, it accept conections normaly and work
fine with the data
I'm trying to understand better what happens to a transaction that is
commited in the middle of a pg_dump. Is the transaction included
in the database dump, or is it excluded.
Example
pg_dump starts
- transaction is begun
- row from table a is deleted
- row from table b is update
On 1/9/06, Chris Hoover <[EMAIL PROTECTED]> wrote:
> I'm trying to understand better what happens to a transaction that is
> commited in the middle of a pg_dump. Is the transaction included in the
> database dump, or is it excluded.
>
AFAIK, it's excluded...
--
regards,
Jaime Casanova
(DBA: Data
On Mon, Jan 09, 2006 at 12:22:27PM -0500, Chris Hoover wrote:
> I'm trying to understand better what happens to a transaction that is
> commited in the middle of a pg_dump. Is the transaction included in the
> database dump, or is it excluded.
If you look at the pg_dump source code or turn on que
On 1/9/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Mon, Jan 09, 2006 at 12:22:27PM -0500, Chris Hoover wrote:> I'm trying to understand better what happens to a transaction that is> commited in the middle of a pg_dump. Is the transaction included in the
> database dump, or is it excluded.If you
"Sistemas C.M.P." <[EMAIL PROTECTED]> writes:
> I had to change the file postgresql.conf (section FILE LOCATIONS -> =
> data_directory)because I need to point to another location.
> But when I reboot the system, it indicates fail (red color) on the =
> startup of postgresql service.
> But then, it
Question,
How exactly is Postgres and Linux use the memory?
I have serveral databases that have multi GB indexes on very large
tables. On our current servers, the indexes can fit into memory
but not the data (servers have 8 - 12 GB). However, my boss is
wanting to get new servers for me but doe
On 1/9/06, Chris Hoover <[EMAIL PROTECTED]> wrote:
>
>
> On 1/9/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> > On Mon, Jan 09, 2006 at 12:22:27PM -0500, Chris Hoover wrote:
> > > I'm trying to understand better what happens to a transaction that is
> > > commited in the middle of a pg_dump. Is th
On Sun, Jan 08, 2006 at 10:57:21AM +0200, Tsirkin Evgeny wrote:
>
> Jim C. Nasby wrote:
>
> >Personally, I'd just put the effort into setting up the insert/delete
> >stuff and a means to periodically roll that info up into a summary
> >table. I know that this has come up in the past, so you can p
On Mon, Jan 09, 2006 at 01:54:48PM -0500, Chris Hoover wrote:
> Question, if I have a 4GB+ index for a table on a server with 4GB ram, and I
> submit a query that does an index scan, does Postgres read the entire index,
> or just read the index until it finds the matching value (our extra large
> i
On Fri, Jan 06, 2006 at 10:23:46PM -0500, Skriloff, Nicholas wrote:
> I installed 8.1 in windows XP SP2 in C:\Program Files\PostgreSQL\8.1\
> --the default-, but not as a service, and would like to find some
> helpful bat files for things like starting and stopping the server. Is
> there a place
Hi,
I have postgres
8.1.1 running on Windows Server 2003. I don't know why my server did stop and
now I'm not able anymore to start the server.
When I start the
server, the service start and shut down immediately. Nothing is written in the
log file. I did check the *.conf files and every
12 matches
Mail list logo
