Why this wonder dabase don't have COPY with fixed columns width?
Or how to do it.
Thanks
_
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.latam.msn.com/
---(end of broadcast)-
I have an application schema which owns several tables. I'm trying to
pg_dump selective tables so that I can restore them into a different
server. I'm getting an error:
pg_dump myDBname --table='transaction mortgage summary_county'
--schema=apps > select_tables.out
pg_dump: WARNING: owner
Am Mittwoch, 21. September 2005 10:16 schrieb Scott Eade:
> Is it necessary for me to convert the database to some other encoding
> (e.g. UNICODE) before I can store non-LATIN1 characters or does
> PostgreSQL catch these and encode them somehow?
Yes and no.
> I have actually been attempting to co
[EMAIL PROTECTED] (Robert Ngo) writes:
> Robert Ngo wrote:
>
>> Chris Browne wrote:
>>
>>> [EMAIL PROTECTED] (Robert Ngo) writes:
>>>
>>>
Can i create create a cluster of postgresql server by sharing the
database file on a SAN? I am also looking into slony but slony
replicate
d
Scott Eade <[EMAIL PROTECTED]> writes:
> Environment: PostgreSQL 7.3.10-RH, RHEL3
> PANIC: open of /var/lib/pgsql/data/pg_clog/0058 failed: No such file
> or directory
> I am wondering if anyone can point me to the supposedly fixed bug that
> would have caused this (is it just me or is it diff
On Wed, Sep 21, 2005 at 06:16:31PM +1000, Scott Eade wrote:
> I have a database that was created using the LATIN1 encoding.
>
> Is it necessary for me to convert the database to some other encoding
> (e.g. UNICODE) before I can store non-LATIN1 characters or does
> PostgreSQL catch these and encod
On Tuesday 20 September 2005 13:55, Chris Hoover wrote:
> I have a question on disk access.
>
> How often is PostgreSQL accessing/touching the files that are on the hard
> drive?
>
> What I'm trying to ask is, is PostgreSQL constantly updating access
> timestamps or something like that on the datab
Hi,
what does "iptables -L" and "/var/log/postgresql" say? Is there a packetfilter? The socket sems to be ok.
Can you telnet to the the socket?
Regards,
Martin
Am Mittwoch, den 21.09.2005, 16:08 +0800 schrieb Nirav Parikh:
Hi Martin,
Thanks for prompt reply. As I said before
I have a database that was created using the LATIN1 encoding.
Is it necessary for me to convert the database to some other encoding
(e.g. UNICODE) before I can store non-LATIN1 characters or does
PostgreSQL catch these and encode them somehow?
I have actually been attempting to convert a database
Hi
Martin,
Thanks for prompt reply. As
I said before I can connect through different server but can't connect locally.
This is the result
of netstat -anp | grep
postmaster
tcp
0 0
0.0.0.0:5432
0.0.0.0:*
LISTEN
2094/postmastertcp
Hi,
check "port = 5432" in postgresql.conf and have look to "netstat -anp | grep postmaster"...
Best regards,
Martin
Am Mittwoch, den 21.09.2005, 15:30 +0800 schrieb Nirav Parikh:
Hi,
I build the new server running FC4. I am having problem connecting to Postgresql data
Hi,
I build the new
server running FC4. I am having problem connecting to Postgresql database from
php. I get the following error message when I am trying to
connect
"DB_Error Object (
[error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -24
[message] => DB Error: connect
> Hi,
>
> Can i create create a cluster of postgresql server by sharing
> the database file on a SAN? I am also looking into slony but
> slony replicate data to each server and my database will
> potentially have terabytes of data. I am thinking about a
> solution where a cluster of database s
13 matches
Mail list logo
