ffers, maintenance_work_mem and other related parameters?
Regards,Ikram
On Fri, Jul 26, 2024 at 10:31 AM sivapostg...@yahoo.com
wrote:
Hello,Using PG 11.11, One PG Cluster, Windows 2019 Server Standard, Two
databases with identical data.
1. First DB: client_db
2. Second DB: client_test
Took b
Hello,Using PG 11.11, One PG Cluster, Windows 2019 Server Standard, Two
databases with identical data.
1. First DB: client_db
2. Second DB: client_test
Took backup (pg_dump) of first database (client_db) and restored the database
as second database (client_test).
Query:
Select a.examname, a.r
On Saturday, 20 July, 2024 at 10:55:30 pm IST, Francisco Olarte
wrote:
Hi:
Please, avoid top posting, specially when replying to long mail with
various points,m it makes it nearly impossible to track what you are
replying to.
OK
On Sat, 20 Jul 2024 at 13:44, sivapostg...@yahoo.com
On Sunday, 21 July, 2024 at 12:52:22 am IST, Michael Nolan
wrote:
On Thu, Jul 18, 2024 at 4:38 AM sivapostg...@yahoo.com
wrote:
>
> Hello,
> PG V11
>
> Select count(*) from table1
> Returns 10456432
>
> Select field1, field2 from table1 where field3>
ace the old database with the backup. Is that only option?
Happiness Always
BKR Sivaprakash
On Thursday, 18 July, 2024 at 05:23:39 pm IST, Francisco Olarte
wrote:
On Thu, 18 Jul 2024 at 11:38, sivapostg...@yahoo.com
wrote:
> Hello,
> PG V11
>
> Select count(*) from table1
>
Hello,PG V11
Select count(*) from table1Returns 10456432
Select field1, field2 from table1 where field3> '2024-07-18 12:00:00' Times out
The above query was working fine for the past 2 years.
Backup was taken a day back. Need to recover complete data as far as possible.
Any possible way(s) to do
k, batchnumber, expirydate, receivedquantity,
receivedfreequantity
in all the 4 tables that this view got.
Happiness Always
BKR Sivaprakash
On Saturday, 17 September, 2022 at 03:33:48 pm IST, Peter J. Holzer
wrote:
On 2022-09-17 05:28:25 +, sivapostg...@yahoo.com wrote:
> My
Hello,
My query is like this
Select a.field1, a.field2, a.field3From (Select a.field1, b.field2, c.field3
From table1 a Join table2 b on b.something =
a.something Join table3 c On c.something = a.something
Where a.field7 = 'value'
here.
Happiness Always
BKR Sivaprakash
On Monday, 22 August, 2022 at 03:54:30 pm IST, jian he
wrote:
On Mon, Aug 22, 2022 at 12:59 PM sivapostg...@yahoo.com
wrote:
Hello,Using PG 11.4
We populate constraint string dynamically and add it to the table with alter
table command. It gets
Hello,Using PG 11.4
We populate constraint string dynamically and add it to the table with alter
table command. It gets added, but without the required brackets. What we
build isALTER TABLE public.tx_barcode_stock ADD CONSTRAINT
"tx_barcode_stock_CK1" CHECK ( (branchcode = '1'::bpchar and bar
Hello,
I see 'identity' column values increment even when some error(s) occurs while
inserting data. Is that a known bug or known behavior?
Create script of table: CREATE TABLE public.users(
id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1
MI
Hello,
I need to create a Foreign Key for a table without enforcing the constraint for
existing data. Few orphan exists in existing data, which we plan to resolve
it later.
We use the following query to create the FK [ Which of course checks for the
presence of record in referencing table]
A
Should manually do pg_dump and then copy the resultant one to the destination?
Sent from Yahoo Mail on Android
On Sat, Feb 5, 2022 at 10:32 AM, Benedict
Holland wrote: Pg_dump or do a wal archive.
Thanks,Ben
On Fri, Feb 4, 2022, 10:49 PM Ron wrote:
On 2/4/22 9:14 PM, sivapostg
Not done so far. Started using A2 for production just a couple of months back.
Sent from Yahoo Mail on Android
On Sat, Feb 5, 2022 at 9:19 AM, Ron wrote:On
2/4/22 9:14 PM, sivapostg...@yahoo.com wrote:
Hello, Got few (currently 3 will increase as days go) database in A2 hosting
Hello,Got few (currently 3 will increase as days go) database in A2 hosting
unmanaged vps server, running Ubuntu server 18 lts
Planning to have an additional backup of all files, including pg database, to
another cloud provider like Amazon S3 (any other suggestions?)
Size won't be crossing 5GB pe
Corrupt windows user was the reason that we found. When tried from other
windows users, it's working. So switched to a new windows user and everything
seems perfect.Thanks.
On Thursday, 25 November, 2021, 11:11:56 am IST, sivapostg...@yahoo.com
wrote:
Hello
PostgreSQL
Hello
PostgreSQL 11.11, PGAdmin 4.27, Windows 10 Pro 20H2
Working fine till yesterday (24.11.2021). When we tried to connect from
PGAdmin, it refused to list server list. Thought of some corruption happened,
we tried to add a server we got the following error message
What could be the reason
Hello,
Planning to go for a new database server. Should opt for more cores or higher
GHz ? Using one base server (with SQL Server) which is ageing. Now switched
to PostgreSQL. More load will be there during festival seasons (Deepavali)
only and we need to plan for that load only. There
Hello,
We want to carry out some data manipulation work in a database exclusively.
We don't want any one to connect this database during that time. How to do it
?
In SQL Server there are two ways [ earlier we used SQL Server and now switched
to PG ]1. Change the database to work in single-u
.conf will however need to have an IP address/netmask. So if you are
connecting from within your local network, you can put something like:
hostssl all all 192.168.0.0/16 md5
Hth?
On Wed, 30 Jun 2021 at 15:54, sivapostg...@yahoo.com
wrote:
Hello,
Using PostgreSQL 11
Curr
Hello,
Using PostgreSQL 11
Currently connecting PostgreSQL database from our Powerbuilder application
using the IPAddress as Server Name through ODBC driver. Would like to know
whether we can connect naming the computername instead of IP Address ? If yes,
what info to be entered in pg_hba.conf
R Sivaprakash
On Sunday, 9 May, 2021, 07:49:57 am IST, sivapostg...@yahoo.com
wrote:
1. First why switch the computer off for lunch? It's a development
machine and I'm a developer. We used to shut down every computer for lunch.
We shut down the windows and not
1. First why switch the computer off for lunch? It's a development
machine and I'm a developer. We used to shut down every computer for lunch.
We shut down the windows and not just hit the power switch. We advice and
follow every users and client to shut down the windows properly
Or server’s log file is available elsewhere ?
On Saturday, 8 May, 2021, 01:24:50 pm IST, sivapostg...@yahoo.com
wrote:
The above is the contents of the log file from 'data' folder of PG.
Message in Windows Application Event2021-05-08 10:26:19.425 IST [5588] LOG:
li
On Friday, May 7, 2021, sivapostg...@yahoo.com wrote:
Hello,
PG 11.8 in Windows 10 and currently PG 11.11
Yesterday [07th May] morning when we switched on the computer and subsequently
PGAdmin, we got the message following messageFATAL: the database system is
starting up
I uninstalled PG and in
Hello,
PG 11.8 in Windows 10 and currently PG 11.11
Yesterday [07th May] morning when we switched on the computer and subsequently
PGAdmin, we got the message following messageFATAL: the database system is
starting up
I uninstalled PG and installed [v 11.11] PG with the same data directory.
Fo
formance tuning for postgres
server? There are many documents detailing performance tuning your servers,
like you probably did, at some point, with your sql server.
Thanks,Ben
On Wed, Feb 17, 2021, 8:28 AM sivapostg...@yahoo.com
wrote:
We use datawindows. Datawindows will send the required DM
wait is there >.
On Wednesday, 17 February, 2021, 06:48:35 pm IST, Thomas Kellerer
wrote:
sivapostg...@yahoo.com schrieb am 17.02.2021 um 13:01:
> To populate some basic data we try to insert few records (max 4
> records) in few tables (around 6 tables) from one window. We feel
> t
05:35:43 pm IST,
wrote:
- Mensagem original -
> De: sivapostg...@yahoo.com
> Para: "pgsql-general"
> Enviadas: Quarta-feira, 17 de fevereiro de 2021 9:01:15
> Assunto: Re: Slow while inserting and retrieval (compared to SQL Server)
>
> Hello,
>
> Using
Hello,
Using Postgres 11 in Windows Server 2012 & PowerbuilderWorking from the same
machine where Postgres 11 is installed. So no chance for any network issue, I
feel.
No setup/config change done. Just working with all the default settings.With
no data in any of the 179 tables in that databas
We are an ISV. I agree the risk involved in sharing the data. Still few of
my customers need that facility and are accustomed to it when using SQL Server.
On switch over to PG, I face this issue as a limitation. Need to find and
provide a solution.
For those customers, having good volume
. Work again in the 1st server.
Is this the best way to carry out this process?
Happiness AlwaysBKR Sivaprakash
On Friday, 22 January, 2021, 12:40:05 am IST, Ken Tanzer
wrote:
On Thu, Jan 21, 2021 at 5:52 AM sivapostg...@yahoo.com
wrote:
create database is to create a new database
21/01/2021 13:13, sivapostg...@yahoo.com wrote:
> Hello,
>
> I'm from SQL Server now developing my current project using PG.
>
> In our earlier project(s), we used to copy the database from one server
> to another, work in another server, and re-copy it in the original
>
Hello,
I'm from SQL Server now developing my current project using PG.
In our earlier project(s), we used to copy the database from one server to
another, work in another server, and re-copy it in the original server. All
happened easily with just transferring the two files (mdf & ldf) to our
Hello,
Windows Server 2008 R2, Postgresql 11.8
We formatted our server and tried to install postgres again by setting the same
old data directory. And we got the following error.
There has been an error:Unknown error while running C:\Windows\System32\icards
"D:\PG Data\V11" /T /Q /grant "NT AUT
HFSQL - Not a so popular database allow us to encrypt and password protect
every tables [ they term Tables as Files ]. Without password those tables
could not read even through HFSQL management centre [ like pgadmin].
May be such a facility you refer ?
Sent from Yahoo Mail on Android
On
Hello,Need to set a value of Zero when the field value is NULL in trigger
function.
Tried with,NEW.fieldname = NULLIF(NEW.fieldname, 0)
in before insert/update trigger.
Looks like it's not working. I'm doing anything wrong.
Happiness AlwaysBKR Sivaprakash
* from t where t like 'fo\_%' escape '\';
t
--
fo_
fo_x
(2 rows)
Cheers,
Paul
On Tue, Mar 10, 2020 at 1:49 PM sivapostg...@yahoo.com
wrote:
>
> Hello,
>
> What returns when I run a query like this;
>
> Select * from test where name like 'co_%';
>
Hello,
What returns when I run a query like this;
Select * from test where name like 'co_%';
I expect anything that starts with 'co_' and NOT 'co' only. Am I right? But I
get every names that starts with 'co'. Why ?
Happiness Always
BKR Sivaprakash
Hello,Installed postgresql 11 in CentOS 7 through
yum install
https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install postgresql11
yum install postgresql11-server
/usr/pgsql-11/bin/postgresql-11-setup initdb
Now the commandcreate extensi
Since the no. of entry screens to be locked might increase with
enhancement(s), the approach could be 1. On completion of all entries by all,
say for a day.2. When opening the report, check whether only one user has
logged in. Close the report window, if there are more than one users.3. F
ursday, 27 February, 2020, 10:04:12 pm IST, Ireneusz Pluta/wp.pl
wrote:
W dniu 2020-02-27 o 15:26, sivapostg...@yahoo.com pisze:
> Need to lock around 10 tables. Let me try with pg_advisory_lock().
I am not sure why you mention table locks at this point. Just in case: with
advisory locks
Need to lock around 10 tables. Let me try with pg_advisory_lock().
On Thursday, 27 February, 2020, 07:39:13 pm IST, Ireneusz Pluta/wp.pl
wrote:
W dniu 2020-02-27 o 14:37, sivapostg...@yahoo.com pisze:
> Hello,
>
> I'm saying isolation will not work out to my requiremen
wrote:
W dniu 2020-02-27 o 12:35, sivapostg...@yahoo.com pisze:
> I need to prevent other users from entering any transaction till I finish
> taking reports from my
> application. All users will be using the same application, from which this
> report is supposed to
> be printed.
&
Well,
I need to prevent other users from entering any transaction till I finish
taking reports from my application. All users will be using the same
application, from which this report is supposed to be printed.
If they enter any data, those data also need to be taken into account in this
re
Hello,
Before taking a few reports, we need to ensure that only one connection is made
to the database and all other computers need to close the connection to that
database. This is to prevent any additional entry(ies) that could be made
during the course of the report taking. This single-use
& OS) at a
time.
We'll be using either pg_basebackup or pg_dump, as suitable, till we find a
good backup solution.
On Tuesday, 25 February, 2020, 07:24:00 pm IST, Stephen Frost
wrote:
Greetings,
* sivapostg...@yahoo.com (sivapostg...@yahoo.com) wrote:
> HiCan u su
HiCan u suggest a good backup solution for a windows installation ? Looks
like the suggested two [ pgbarman, pgbackrest ] works only in Linux.
On Tuesday, 25 February, 2020, 01:46:33 am IST, Stephen Frost
wrote:
Greetings,
* Dor Ben Dov (dor.ben-...@amdocs.com) wrote:
> What is your
It could also be done by putting those values in square bracket, if
substituted with default values.eg. [0] 4 45 [100]Values
within square brackets are default values.
On Sunday, 23 February, 2020, 04:52:11 pm IST, Peter J. Holzer
wrote:
On 2020-02-22 16:02:06 -05
49 matches
Mail list logo