Is postgres actually running? And is your pg_hba.conf file configured
to allow local UNIX socket connections?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 16, 2005,
After a long battle with technology, [EMAIL PROTECTED] (prakash sompura), an
earthling, wrote:
> Can any one tell me how do I replicate my PostgreSql database from
> one server to another server?
One method involves using pg_dump to dump the state out, and load it
onto the other server. Certainl
Christopher Smiga <[EMAIL PROTECTED]> writes:
> ... I performed something that causes the following FATAL ERROR
> when trying to get back into "psql"
> [EMAIL PROTECTED]:~$ psql booktown
> psql: FATAL: invalid value for parameter "datestyle": "SQL US"
> Does anyone have an idea to how I can cor
No, I mean JDBC version, not JDK version.
go to jdbc.postgresql.org and download newest version of JDBC to
have a try.
regards laser
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining colum
Hello Hackers,
I store some information of manufacturing materials in a table, and in
this table there's a column storing material's name. These names are mixed with
Chinese characters and English characters.
To convert all English characters in material names into lower cases, I
what' your JDBC version?
if it's pretty old, then upgrade to newest one is a bet.
Don't know if it could solve the problem, but old
version of JDBC did have some problem in transaction
handling, we've experienced such problem not so long
before.
regards laser
---(end of broa
I just upgraded a machine to Fedora Core 3 and now on startup pgsql gives
me the message "An old version of the database format was found" and
refuses to start.
I'm not entirely sure how to fix this (everything I've read says I
should've taken some steps before the upgrade) but since the only datab
"Michael" <[EMAIL PROTECTED]> writes:
> I run pg_dump -s to back up my database and get this error message:
> pg_dump: could not parse ACL list =
> ([0:1]=3D{pgsql=3DUC/pgsql,=3DUC/pgsql}) for=20
> object "public" (SCHEMA)=20
> Can someone tell me why?
You're using a buggy beta version.
[EMAIL PROTECTED] (Michiel Lange) writes:
> Hello list,
>
> I am trying to create a table that hould countain a number formatted
> this way: MMDD##
>
> Where the hashes should be padded to '0'.
I think you can get to where you want to go with
to_char(current_date, 'MMDD')
I just upgraded a machine to Fedora Core 3 and now on startup pgsql gives
me the message "An old version of the database format was found" and
refuses to start.
I'm not entirely sure how to fix this (everything I've read says I
should've taken some steps before the upgrade) but since the only datab
I'm working through the Oreilly "Practical PostgreSQL" book and I
implemented "booktown.sql" to work examples in the book. Anyway, in
chapter 3, I performed something that causes the following FATAL ERROR
when trying to get back into "psql"
[EMAIL PROTECTED]:~$ psql booktown
psql: FATAL: inval
Can anyone tell me how to successfully migrate from 7.1.3. to 7.4.7.? I get
lots of errors...
Tank you!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi list!!
I tested pgpool with pgpool.conf as follows:
listen_addresses =
'localhost'
port =
socket_dir = '/tmp'
backend_host_name = ''
backend_port = 5432
backend_socket_dir =
'/tmp'
secondary_backend_host_name
= ''
secondary_backend_port =
0
num_init_children = 15
m
I am using an open source sw for a test forum, but if I insert in my message some
special character like à,è,ì
... when I submit the topic I get the following error message:
Error in posting
DEBUG MODE
UPDATE elca2Forum_posts_text SET post_text = 'la città', bbcode_uid
Hi
Can any one tell me how do I replicate my PostgreSql database from one
server to another server?
Prakash
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I am not sure if I am doing something wrong or a hit a bug, so here it goes:
I am running PostgreSQL 8.0.1 under Windows 2000. We have this database
here which is really small and has a set of 5 functions. All the
functions are programmed using pgpsql so we used the functionality where
we can us
Hi, all,
I run pg_dump -s to back up my database
and get this error message:
pg_dump: could not parse ACL list ([0:1]={pgsql=UC/pgsql,=UC/pgsql}) for
object "public" (SCHEMA)
Can someone tell me why?
pgsql is the username.
postgresql version:pre-release version of
postgresql 7.5 window
I'm using pgpool in a fairly high-traffic environment, and I regularly
get this warning from pgpool calling ABORT:
WARNING: there is no transaction in progress
I found this post in the archives:
http://archives.postgresql.org/pgsql-general/2004-04/msg01154.php
But the README for pgpool asserts:
Thank you, that is the best news I have heard in a while :-)
-Mont
On Mar 19, 2005, at 6:49 PM, John DeSoi wrote:
On Mar 18, 2005, at 5:54 PM, Mont Rothstein wrote:
I need to store multiple languages in one database (English, Spanish,
Chinese, Korean, ???). At first I thought I would just us Unic
19 matches
Mail list logo