Hi,
Please explain me is there any difference if i load my
files(like gif or any images files) into the data base as text
format?
Bcoz,I have loaded my image files in a text format into the database and
when i exported it into my local file system the content of the original
file(i.e. imp
I had this when I first started out with PGSQL a few years ago - if you have
any upper-case names in schemas or tables, pgAdmin doesn't seem to like it,
and (in my scenario) even if you put the table name in the query in the
correct case, it still wouldn't recognise it.
I've since found it's best
o import a database mapped in a lot of dbf
files.
Thanks in advantage
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Partecipa al concorso Best Western, ogni giorno puoi vincere un fantastico
week end da sogno!
Clicca qui: http://adv.email.it/cgi-
I would think a data type with the likes
of “binary” (bytea?) would be more appropriate. It’s like trying
to upload an image via FTP in ASCII format – it never comes out the same
the other end.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of sandhya
Sent: 11
gt; Is there a standard proceure to import a database mapped in a lot of dbf
> files.
>
>
>
>
> Thanks in advantage
>
> --
> Email.it, the professional e-mail, gratis per te: http://www.email.it/f
>
> Sponsor:
> Partecipa al concorso Best
hi
...
Its like trying
to upload an image via FTP in ASCII format it never comes out the same the
other end.
Which one you are
referring ?You mean
If i load files using
lo_import into DB and when i export it and see the content is
different right!!!
But i read in postgres document as
Is there any document which explains clarly about how to load
files in binart format and how to retrieve itAs far as i read i got only
files storing in OID format.
Thanks for your help...
Sandhya
- Original Message -
From:
Andy Shellam
To: 'sandhya'
Cc: pgsql-a
Can PostgreSql work with dbf tables?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Just to say thanks to all for your constructive and helpful replies - I
will build a new server with 8.1 and slony.
Steve
Steve Burrows wrote:
I am struggling to find an
acceptable way of backing up a PostgreSQL 7.4 database.
The database is quite large, currently it occupies ab
On May 04 04:50, Vadim Pestovnikov wrote:
> When I create a database dump in python script and if there are some
> errors (user_name is not correct, db_name doesn't exist or something
> else) I need to send e-mail notification to admin. How can I handle
> these errors?
I don't think this has anyth
Hi,
Already i have postgres server running on my windows
system.Suddenly when i open it didn't open and when i run and see in the
services...I am getting the following.Can any one please explain me why this
problem is coming?Will i lost all my data in it.I am not getting any problem
with my
corso Best Western, ogni giorno puoi vincere un fantastico
week end da sogno!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5096&d=20060511
---(end of broadcast)---
TIP 6: explain analyze is your friend
---(end
Title: Fatal: 2149478 (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Hello -
I am trying to set up my postgresql.conf file for Postgres 8.1. I am setting up the maintenance_work_mem (this has also happened with the work_mem) and I receive this error:
Fatal: 2149478
Title: Fatal: 2149478 (UNCLASSIFIED)
Not sure
what type of system you are running postgres on but that error may mean that
you have to bump up the SHMMAX setting in the kernel. In Linux it is set in the file /etc/sysctl.conf and in UNIX
it is set in the file /etc/system. I know in Linux y
Crowson, Sarah J Ms (Contractor) Northrop Grumman wrote:
> I am trying to set up my postgresql.conf file for Postgres 8.1. I am
> setting up the maintenance_work_mem (this has also happened with the
> work_mem) and I receive this error:
> Fatal: 2149478 is outside the valid range for para
Fatal: 2149478 is outside the valid range for parameter
"maintenance_work_mem"
That is odd. I just testing on 8.1.3:
template1=# set maintenance_work_mem = 2149478;
SET
template1=#
Oh wait.. duh! :)... Remember that maintenance_work_mem is in "k". The
max you are going
BTW, your email almost got marked as spam:
X-Spam-Status: No, score=4.1 required=5.0 tests=BAYES_00,DNS_FROM_RFC_ABUSE,
NO_REAL_NAME,RCVD_HELO_IP_MISMATCH,RCVD_NUMERIC_HELO
autolearn=no version=3.1.0
On Thu, May 11, 2006 at 09:24:35AM +0200, [EMAIL PROTECTED
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> Fatal: 2149478 is outside the valid range for parameter
>> "maintenance_work_mem"
> That is odd. I just testing on 8.1.3:
> template1=# set maintenance_work_mem = 2149478;
> SET
I'm betting Joshua is testing on a 64-bit machine. Si
Classification: UNCLASSIFIED
Caveats: NONE
I am currently working on figuring out the size of my systems. It looks to
me like I am dealing with 2 gig systems.. Although on our road servers (we
travel) we are dealing with 12 gig systems. Unfortunately I have had hit
or miss problems with these w
That is odd. I just testing on 8.1.3:
template1=# set maintenance_work_mem = 2149478; SET
I'm betting Joshua is testing on a 64-bit machine. Since 8.1, the max
allowed value is dependent on sizeof(pointer) ...
Oops... yes my test workstation is a Dual Core AMD64.
Sincerely,
Joshua D. D
Question, Can you set both the log_rotation_age and log_rotation_size? If so, does either one have presidence over the other? I would like to have both on and am hoping that you will tell me that they work together.
So, if log_rotation_age = 1440, and log_rotation_size = 1048576 then my log will
please unsubscribe!
Regards
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> Can you set both the log_rotation_age and log_rotation_size?
Sure. It'll rotate whenever either limit is reached.
regards, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9
23 matches
Mail list logo
