Hi all,
Some days ago I need to reinstall postgresql 6.3.2. Before doing
this I made a backup of my databases just copying the files in
/var/lib/pgsql. Did I make the backup correctly?
After that, I install postgres (6.3.2). Then, I copied my
databases into the
Hi all,
I'm a little bit curious with a message I've been receiveing
all times I connect to a database.
When I run "psql chs" I receive this message.
>Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
Hy all,
I'm using the delete command with "PQexec" to remove some records from
my database. But there is a problem, how can I know if the record was
really removed if the values returned in "PQresultStatus" are the same
when no records and one record are removed. Should I use a special
function
I get the "FATAL 1" message from "postgres -i":
[postgres@lexis postgres]$ postgres -i
FATAL 1: Database postgres does not exist in pg_database
FATAL 1: Database postgres does not exist in pg_database
[postgres@lexis postgres]$
What may I be doing wrong?
(By the w
Hello,
I'm new to the list, and I'm intereted in PostgreSQL replication (using WAL)
As I didn't find any script to do that, I make mine, that seems to work.
However, I wonder how can I "switch WAL logs", in order to have the standby
database not too much late.
The database actually generates few
archives_mydb1/"%f"'
#
# This script can probably run in other conditions, but in my case I had :
#- PGDATA=/var/lib/postgresql/data
#- database user : postgres
#- postgres home in /var/lib/postgres
#- sed
#- postgresql 8.1.2
#
#
# Known problems/missing features
Hi,
Is it possible to set a custom session variable and/or global variable in
plpgsql ?
Regards,
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
help
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Mon, 12 Jan 2004, kandiah ratnavale wrote:
> -bash-2.05b$ whoami
> postgres
> -bash-2.05b$ su - bruce
> su: user bruce does not exist
> -bash-2.05b$ createuser bruce
> Shall the new user be allowed to create databases? (y/n)
> Shall the new user be allowed to create mo
On Tue, 09 Mar 2004, Louie Kwan wrote:
> Not a PGSQL question..
>
> When I use vim, my xterm is all highlighted with many different color..
>
> How can I turn the coloring off.
>
> Sorry to ask the vim question here.
Numerous ways.
In a session:
:syntax off
Presumably, you're using files wi
Hi!
I run pg7.4 on a SuSE 9.1 (IPv6) machine (linux 2.6); despite I added
hostall all ::1
:::::::password
to my pg_hba.conf, connecting to the database via JDBC (pg74.213.jdbc3.jar)
fails:
org.postgresql.util.PSQLExcep
On Wed, 11 Feb 2004, Christopher Browne wrote:
> A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jodi Kanter) wrote:
> > Do constraints effect performance significantly?
>
> They would be expected to provide a significant enhancement to
> performance over:
> a) Firing triggers,
>
On Wed, 12 Jan 2005, Goulet, Dick wrote:
> Whatever, I'll keep root only for absolutely restricted use & install
> under a separate user account. Works just fine & it makes the auditors
> & sysadmin feel better.
Unfortunately, I _know_ how auditors think, but I would hope that a
sensible compan
i'm an actual newbie when it comes to postgres.
how do i set the pg_hba.conf for a password authentication? how do i set
the ps_pwd and other needed configuration?
and lastly, where can i find a detailed document on configuring postgres?
thanks.
samil buri.
On Tue, 26 Jan 1999, Oliver Elphick wrote:
> Postgres GOD wrote:
> >how do i set the pg_hba.conf for a password authentication? how do i set
> >the ps_pwd and other needed configuration?
>
> Here is a document I put together on the subject. (If anything in it ha
i know this one is easy one to those postgres guru.
how can i deal with this vacuum problem?
NOTICE: CreatePortal: portal already exists
ERROR: can't create lock file -- another vacuum cleaner running?
thanks.
samil.
'winning w/o fighting is best!'-suntzu.
i would like to know what is the maximum attribute record that can class
can accomodate.
i'm having problem with one of my table(class) it hangs-up during
insertion.
i'm using the libpq in my c script as the programming interface for
postgres.
samil buri.
I have some clients that are looking to upgrade to MSSQL Server because
they use ACT!. I'm developing a web application for them that uses
PostgreSQL. Does anyone know if ACT! can use PostgreSQL? or if I can
hack it?
Suggestion welcome and Thanks,
J
---(end of broadcas
I have a client who wants to use Delphi as a front end to a Database, I
would like to use PostgreSQL over MSSQL and have been looking at the
psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm
wondering if anyone has experience with it? Any help will be appreciated.
Thanks,
J
::1 is a function of the PHP $_SERVER[''] internal function, not a
PostgreSQL problem. It will display ::1 on any database, you program a
PHP custom function to call the whole IP address. The real question is
that a problem in a production environment? Of note, outside IP
addresses will display fi
Sorry for the attachment, but copying and pasting this data does not work.
I don't have any idea how to insert the type of data into PostgreSQL.
Basically, it's encrypted data in which I would like that keep raw format.
Thanks for any help,
J
sample_data.pdf
Description: Adobe PDF document
--
Can I do something like this:
CREATE TABLE sample (id SERIAL, node INTEGER, parent INTEGER);
INSERT INTO sample(node,parent) VALUES(1,0);
INSERT INTO sample(node,parent) VALUES(2,0);
INSERT INTO sample(node,parent) VALUES(3,1);
INSERT INTO sample(node,parent) VALUES(4,3)
CREATE OR REPLACE FUNCTIO
I have data in one table called articles and I would like to make a
function in which takes certain data from it and display the results.
Example:
CREATE TABLE articles (
article_id serial,
title varchar(200),
posted timestamp,
article_subject varchar(200),
article_body text,
allow_comments boole
Are you a good Unix/PostgreSQL admin with some MySQL experience? Do you
want to help a company migrate off of MS SQL Server? Do you want to live
and work in Las Vegas for a fun company of good computer techs?
We need you. Contact me.
--
Tim Ellis
Senior Database Architect and author, tedia2sql (
I'm new to PostgreSQL, and am wondering for BindSQL is intergrated in
Postgres or in the future for version 8.
Example:
SELECT * FROM sample_table WHERE computer = :1;
Any pointers will help.
Thanks,
J
---(end of broadcast)---
TIP 1: subscrib
Do you mean PREPARE / EXECUTE?
/* [EMAIL PROTECTED]:5432/ahammond =# */ \d foo
~ Table "public.foo"
~ Column | Type | Modifiers
- +-+--
~ foo_id | integer | not null default nextval('foo_id_seq'::
I'm writing a web application inwhich clients will login/out among other
stuff. I have be reading on prepared statements and leave you all with
an open-ended question. Are prepared statements better and how can I
program them to not end at the once the session is over?
Thanks, any other sugges
Joshua D. Drake wrote:
Use a connection pooler like pgpool.
Thanks for the suggestion, I will look into it and test. There seems to
some overhead using that tool. What about custom functions, written in
SQL or C? They seem to work until the database is shut down, any
thoughts about that for a c
What are the advantages to SQL Functions? I'm looking to optimize
'default' PostgreSQL environments for clients. I'm writing an
application and looking to put functions to optimize just that table,
etc. They don't want to have a full-time database admin (surprise!).
Thanks,
J
-
You're php install isn't finding the postgresql libs it needs. When you
do the ./configure --with-pgsql check the output of the config run, and
you'll see something like:
checking for PostgreSQL support... no
You may want to set include flags when compiling
CPPFLAGS=-I/usr/local/pgsql/inc
On Fri, 2003-06-06 at 09:42, Kris Kiger wrote:
> I'm looking for a good way to monitor disk I/O on a linux
> system. Specifically, I would like to know when postgres is making
> page-ins and page-outs. If anyone knows of a good utility, please let
> me know! Thank you for
/pgsql/lib and PGDATA=/usr/local/pgsql/data). But when I
run "createdb" to test things out I get this:
...
[postgres@catclaw bin]$ createdb
Connection to database 'template1' failed.
FATAL 1: Database template1 does not exist in pg_database
createdb: database creation failed on
Hi,
What are steps/code for Record-based Log Shipping postgres 8.2?
If use Record-based Log Shipping can I access both primary and standby
server simultaniously.
Tarun
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
gresql Database\data.
>> I quoted it with double quotes. Without -D postgres.exe complained
>> about not finding the data path, with it postgres.exe complained about
>> not finding the config file, stating that it looked in (from memory
>> vague) F:\Postgresql Database\data\
On Thu, October 16, 2008 06:47, Carol Walter wrote:
> Let me see if I understand this correctly.
> Always do a backup before doing any destructive sys admin functions. =)
> First, I run configure, taking care to make sure all the options point
> to the right places.
> Second, I run gmake
> Third,
On Tue, November 3, 2009 10:10, Scott Marlowe wrote:
> On Tue, Nov 3, 2009 at 1:53 AM, Shruthi A wrote:
>> Hi all,
>>
>> -- Once this service is started, telneting the server on the given port
>> successfully connects.
>> -- Dear Ian Lea, i guess 10.0.0.1/24 is the same as 10.0.0.0/24 as the
>>
An interesting write-up coming from a SQL Server DBA.
http://facility9.com/2011/12/ten-reasons-postgresql-is-better-than-sql-server/
Tim
--
Timothy J. Bruce
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
On Tue, May 8, 2012 07:28, Fred Parkinson wrote:
> I am currently using postgresql version 9.1.3
>
> In the past, when I ran psql and needed useful information provided by
> commands like \h or \d, the information was presented on the screen and I
> could proceed with further commands while viewing
Problem solved, thank you for the responses!
Yes, I had run initdb as outlined in the instructions.
Then I received a tip from someone on the list suggesting:
"do: rpm -qa | grep postgres
then, for each package it returns: rpm -e "
Which I did. At that point, running createdb gave
Hi Folks,
When I write a query with a "WHERE" claused constrained by the "OR"
operator, postgresql creates the enormous pg_sorttemp~ files in
~pgsql/data/base/dbName/ that basically eat up all remaining disk space in
a matter of seconds. These files are 1.8GB+ by the time the partition is
full.
t; table but, forgot to include the name of the table in the query. It was a
> 3 table query and he accidentally included a fourth table field but didn't
> add the table in the clause.
>
> I was suprised to see postgres not error out. Instead it sucked all of the
> CPU from the
The following two SQL Exceptions are popping up after several days or
weeks of seemingly smooth execution:
"Unknown Response Type x" <= where x is a random ASCII character
and
"The column index is out of range"
Once one of these two SQL Exceptions start occurring, pretty much all
queries af
Hello,
After about a year and a half of use, I ran into a peculiar problem
with my PostgreSQL driven app and I would like to understand why.
I have a web app that uses PostgreSQL 6.5.2 on the backend. The app logic
is Java beans and JSP. The OS is RedHat 6.2 i386. Anyways, there are two
ide
43 matches
Mail list logo
