database from "/var/lib/postgresql" cluster directory, without
using service/daemon applications?
Thank you.
--
Area tecnica - Dario Fadda
Promotux Informatica
Via G. Deledda, 40
09047 - Selargius (CA)
Tel. 0708474056
www.promotux.it
[EMAIL PROTECTED]
---(end
ere any missing ???i have configured python libmy box is using freebsd 5.0, python 2.4.2, postgresql-8.1.2
thank you all for your kinness---(end of broadcast)---TIP 4: Have you searched our list archives?
http://archives.postgresql.org-- Atte: Dario Brignardello
anation of the statistics views, check:
http://www.postgresql.org/docs/7.4/interactive/monitoring-stats.htmlHope it helps.Best regardsDario -- Atte: Dario Brignardello
Greetings:
I may be wrong, but you could try using the createdb / dropdb utils
from the pgsql/bin directory, or calling psql with some of the
parameters used by such tools (-c -d , etc).
Hope it helps.
Best regards
Dario
On 12/6/05, Karthik.S <[EMAIL PROTECTED]> wrote:
>
May be... you could dump your schema in plain format, (dump only schema),
create a new database, restore schema, and then do something like
psql -c "select \'pg_dump --table=\'||name||\'--disable-triggers
database_\' from pg_class where (condition that filters system
tables)">dumper.sh
(I'm not s
The new version will update your postgresql packages. It shouldn't wipe your
data files, since /etc/init.d/postgresql script checks if there are data in the
specified directory. Then you must erase those postgresql (rpm -qa|grep
postgres will list packages installed), and install yours.
But, if
1) mmm... create table x as object doesn't seem to be a valid statement You
can create types, or use arrays. But I think you don't need (neither want)
that...
2) (which one is faster?) I'm not sure what are your plans for this tables. How
many rows are you trying to insert into address for
this line
hostall all192.168.2.120/24 md5
makes no sense to me, and probably neither to postgresql, it should be:
192.168.2.120/32 # if 192.168.2.120 is your client, this should be
enough
or
192.168.2.0/24
Hi...
It seems odd...
1) ?Could you check the user running the service? ?Is it postgres? It
should be, unless you have changed.
2) ?could you try to specify data directory to pg_ctl with "-D"
parameter?
Example:"C:\Archivos de programa\PostgreSQL\8.0\bin\pg_
Did you check file ownership and permissions?
Greetings.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Magnus Hagander
Enviado el: lunes, 15 de agosto de 2005 16:07
Para: Dirk Kalp; pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Server Won't Start On a Copy
?assetkey=1-30-2876-1
for more information.
Regarding the possibility of heartbeats in postgres ... have no idea how
wise would it be ... there's people more qualified here that could
answer that ;-D
Hope this helps, anyway.
Regards.
Dario
On Fri, 2005-08-05 at 09:43 +0200, KÖPFERL Robert
Assuming you are on a linux box (Not sure if it's stated in your mail,
sorry if I miss that) you could set
/proc/sys/net/ipv4/tcp_keepalive_time
to a lower value. That should do the trick :-)
Hope it helps.
Greetings
Dario.
On Wed, 2005-08-03 at 16:48 +0200, KÖPFERL Robert
Assuming you are on a linux box (Not sure if it's stated in your mail,
sorry if I missed that) you could set
/proc/sys/net/ipv4/tcp_keepalive_time
to a lower value. That should do the trick.
Hope this helps
Greetings
Dario
On Wed, 2005-08-03 at 16:48 +0200, KÖPFERL Robert
There shouldn't be problems. "Updating" from 8.0.1 to 8.0.3 is just matter
of changing binaries.
"Upgrading" from 8.0 to 8.1 or 7.3 to 7.4 requires dump, cleaning
directories and restore.
Take a look at forum archives anyway, to confirm this and read about
experiences.
Greetings (saludos /sah loo
Hello. Sorry for mi inglish! :-)
Postgres 7.4 will not access 7.3 PGDATA repository. You must downgrade your
binary files to any 7.3.X (latest is better)
Note: 7.3 won't access 7.4 files neither. Yo can only do sub-sub-version
updates without having to dump and restore (example 7.3.1. to 7.3.9 doe
changed.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Juan Miguel
Enviado el: domingo, 03 de abril de 2005 7:44
Para: Dario Pudlo
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] postgres 7.2.1 pg_restore large objects
Dario Pudlo wrote:
Problem: Not
Problem: Not being able to restore a database with lo. I have already read
forums and doc. Probably I'm loosing something, but I just can figure.
Reading forums I think I finally got the "right" way to do it.
I'm running this as OS postgres which is a super user
pg_dump -Ft -o -b base > base.tar 2
Problem: Not being able to restore a database with lo. I have already read
forums and doc. Probably I'm loosing something, but I just can figure.
Reading forums I though I finally got a "right" way to do it.
I'm running this as OS user "postgres" which is a super user
pg_dump -Ft -o -b base > ba
Problem: Not being able to restore a database with lo. I have already read
forums and doc. Probably I'm loosing something, but I just can figure.
Reading forums I though I finally got a "right" way to do it.
I'm running this as OS user "postgres" which is a super user
pg_dump -Ft -o -b base > ba
Thanks very much to all.
Dario.
Patrice Trognon wrote:
Hi,
If you have blobs you must split your SQL_ASCII to convert it
with iconv.
I export my full database.
I create a new SQL_ASCII database with only tables that don't
contains blobs. (db_without_blobs)
I create a new SQL_ASCII database
Tom Lane wrote:
"Dario V. Fassi" <[EMAIL PROTECTED]> writes:
A simple question, we need to migrate many (>20) postgres databases from
SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server.
SQL_ASCII is not an encoding (it's more like
ing to WIN, ISO-8859-1, and others encodings.
I'm really worried about this problem since , we have many DBs to
migrate and even with a ODBC program we can't port tables from
Postgresql/SQL_ASCII to Postgresql/UNICODE.
Any suggestion will be *very* appreciated.
Regards,
Dario.
That's ok, but how can i do that?
I tried something like "Set datestyle='European', but nothing changed!
Please, can you help me!
Thank you,
Dario Ottaviano
"Tom Lane" <[EMAIL PROTECTED]> ha scritto nel messaggio
news:[EMAIL PROTECTED]
> "Dario Ottavi
Hi there...
I write it becouse i need to know where can i get a "SPECIFIC DOCUMENT" with
the "Postgresql Administration Functions" like
- Create User
- Create Group
...
...
..
.
etc.
I just need a Document which explains very shortly every function(as
administrator).
Thanks fo
.
Why?
Is there a way to avoid this?
Tanck you for help!
Dario
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
eatly appreciated. Since now, thanks a lot.
Yours: Dario Brignardello
S/MIME Cryptographic Signature
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Thanks for your help, its working now :-).
Yours:
Dario Brignardello
Tom Lane wrote:
> Dario Brignardello <[EMAIL PROTECTED]> writes:
> > checkpoint_segments = 1
> > checkpoint_timeout = 30
>
> Reducing checkpoint_segments and checkpoint_time
eatly appreciated. Since now, thanks a lot.
Yours: Dario Brignardello
S/MIME Cryptographic Signature
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
28 matches
Mail list logo
