How to properly shutdown pg db server?
Is the below command safe to shutdown the pg db server?
#killall -9 postmaster
pg_ctl does not
seems work on server?
Regards,
Ganesan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NEVER kill -9 a postmaster
Althoug funny enough it pretty often tolerates that kind of killing, it will
not allow the process to properly shut down the database. So you may or may
not be lucky to end up with a good database.
Use something like
/usr
All,
I did a pg_dumpall in preparation for moving one of our databases from
PG7.3 to PG7.4, but I just realized I have another problem: that DB
(which has served us faithfully for some time) was created for superuser
'postgres,' whilst our new DBs use a superuser name that's aligned with
our pr
W liście z pon, 15-12-2003, godz. 16:30, Rich Cullingford pisze:
> All,
> I did a pg_dumpall in preparation for moving one of our databases from
> PG7.3 to PG7.4, but I just realized I have another problem: that DB
> (which has served us faithfully for some time) was created for superuser
> 'po
In my opinion, the only thing you need to change is the name of the
superuser in your dump file.
Bruno
Rich Cullingford wrote:
All,
I did a pg_dumpall in preparation for moving one of our databases from
PG7.3 to PG7.4, but I just realized I have another problem: that DB
(which has served us
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> NEVER kill -9 a postmaster
> Althoug funny enough it pretty often tolerates that kind of killing, it will
> not allow the process to properly shut down the database. So you may or may
> not be lucky to end up with a good database.
The database is
Rich Cullingford <[EMAIL PROTECTED]> writes:
> I did a pg_dumpall in preparation for moving one of our databases from
> PG7.3 to PG7.4, but I just realized I have another problem: that DB
> (which has served us faithfully for some time) was created for superuser
> 'postgres,' whilst our new DBs
__
Acabe com aquelas janelinhas que pulam na sua tela.
AntiPop-up UOL - É grátis!
http://antipopup.uol.com.br/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Tom Lane wrote:
Rich Cullingford <[EMAIL PROTECTED]> writes:
I did a pg_dumpall in preparation for moving one of our databases from
PG7.3 to PG7.4, but I just realized I have another problem: that DB
(which has served us faithfully for some time) was created for superuser
'postgres,' whilst our
Rich Cullingford <[EMAIL PROTECTED]> writes:
> Hmmm, how do you use 7.4 utilities against a 7.3 DB?
pg_dump can dump from prior-release DBs (back to 7.0 at the moment).
Just point it at the older DB's port.
This is a bit tricky when installing from RPMs, since there's no really
easy way to instal
Hello.
I've had some experience with postgresql on Windows
under cygwin. Is it possible to statically compile
postgresql binary with the cygwin dlls so that I end
up with a standalone windows executable? Internally it
would still require the "unix" way of naming paths,
but a few registry keys wou
Tom Lane wrote:
Rich Cullingford <[EMAIL PROTECTED]> writes:
Hmmm, how do you use 7.4 utilities against a 7.3 DB?
pg_dump can dump from prior-release DBs (back to 7.0 at the moment).
Just point it at the older DB's port.
This is a bit tricky when installing from RPMs, since there's no really
eas
What I want is some support from this good community to give me some
1. Tips
2. Links
3. Advise
for FoxPro and its limits (As could be told to a layman) as how to
crush my competitor for M$ tools,
Its time to prove The M$ Guys that they have $ Power and we the
GNU people have a
social pers
Rich Cullingford <[EMAIL PROTECTED]> writes:
> Well, I was gonna use pg_dumpall to avoid the tedium of individual
> dumps, but (gotcha!) pg_dumpall doesn't accept
> --use-set-session-authorization (tho' it does run pg_dump!). If I use
> pg_dumpall, will pg_restore (with --use-set-session-authori
Just to add a tidbit on top of this, there are commercial RDBMS's that
do, or at least say they do, clustered database servers. (cough cough
oracle, cough cough ingres)
The products are expensives as all get out, a bastard to set up, and
require truely kickass SAN storage and clustered hardwar
Could any one let me know is there a way to findout
the rules previously created in the database .
thanks
ganesh
When I tried to create a database with createdb I receive this message:
"unexpected EOF on client connection".
I need your help!
Thanks,
Daniel
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
Hi guys
I have a postgresql server process each running in my
desktop and the laptop.
Both servers have a database called MG with exactly
same scheme/layout. Now I enter the data in to similar
tables but at differing times.
I generally keep the primary keys seperate so that
they don't clash with
He might also want to take a look at SUN's grid - the developement kit and
most of the components are free. Is also supports Linux. I bet with two
Postgres servers in sync via replication and the GRID setup to do the switch
over should one fail it would be as low cost HA he could get.
- O
Hello.
I've had some experience with postgresql on Windows
under cygwin. Is it possible to statically compile
postgresql binary with the cygwin dlls so that I end
up with a standalone windows executable? Internally it
would still require the "unix" way of naming paths,
but a few registry keys wou
You should check in on the OpenOffice.org website discussion group.
There are a great deal of people that follow the politics of M$ there,
especially global trends. They would like to keep to the topic,
OpenOffice but the topics they cover are trends with Linux that affect
many applications includi
Chris,
Thanks -- your answer is 90% of
what I need! As for the other 10%:
Chris wrote:
Our database ( (PostgreSQL) 7.3.5 ) uses Unicode encoding:
[...]
For some reason, If I try to use an extended character (ASCII code >
127) in a string, I get this peculiar res
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Edan Gavish
Oracle DBA
WWIT
Ogilvy & Mather Worldwide, New York
Office: +1 212 237 5759
Fax: +1 212 237 4060
E-mail: [EMAIL PROTECTED]
Privileged/Confidential Information may be contained in this message. If you are not
the addressee indicated in this message (or responsible for deli
Tom Lane <[EMAIL PROTECTED]> writes:
> I don't believe anyone has proposed removing the facility
> altogether. There's a big difference between making the default
> behavior be not to have OIDs and removing the ability to have OIDs.
Right, that's what I had meant to say. Sorry for the inaccuracy.
unsubscribe
Rhaoni Chiu Pereira wrote:
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi,
I was able to migrate the Oracle database to Postgres, including
functions, procedures. Thanks to ora2pg script and postgres documentation
on porting from oracle to Postgres.
I have now two tuff task. We are running Oracle in stadby mode and apply
archive logs at remote place to maintain ou
On Mon, Dec 15, 2003 at 20:03:54 -0800,
[EMAIL PROTECTED] wrote:
> Hi,
> I was able to migrate the Oracle database to Postgres, including
> functions, procedures. Thanks to ora2pg script and postgres documentation
> on porting from oracle to Postgres.
>
> I have now two tuff task. We are runni
Dear all ,
This may be considered an information :
If you have created your table as
WITHOUT OIDS;
Then your data would not be retrieved into
1. OOo 1.1 < versions SpreadSheet
2. StarOffice 7.0 < version SpreadSheet
3. Excel Office XP
Yes pgsqlODBC is used for interface .
For full details please
30 matches
Mail list logo